Mercurial > gemma

changeset 1354:1000e0e71d5a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added missing rights and fixed trigger function.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 26 Nov 2018 15:21:34 +0100
parents d524d6f54f87
children b0ebb77f4ab0
files schema/auth.sql schema/gemma.sql
diffstat 2 files changed, 4 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/auth.sql	Mon Nov 26 15:05:07 2018 +0100
+++ b/schema/auth.sql	Mon Nov 26 15:21:34 2018 +0100
@@ -39,7 +39,9 @@
 GRANT INSERT, UPDATE, DELETE ON
     users.templates, users.user_templates TO waterway_admin;
 GRANT INSERT, UPDATE, DELETE ON
-    waterway.imports, waterway.import_logs, waterway.track_imports TO waterway_admin;
+    waterway.imports, waterway.import_logs, waterway.track_imports,
+    waterway.sounding_results
+    TO waterway_admin;
 
 --
 -- Extended privileges for sys_admin
--- a/schema/gemma.sql	Mon Nov 26 15:05:07 2018 +0100
+++ b/schema/gemma.sql	Mon Nov 26 15:21:34 2018 +0100
@@ -586,6 +586,7 @@
 $$
 BEGIN
     EXECUTE format('DELETE FROM %s WHERE id = $1', OLD.relation) USING OLD.key;
+    RETURN NULL;
 END;
 $$
 LANGUAGE plpgsql;