# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1543242094 -3600
# Node ID 1000e0e71d5a3bd1a8234e433af57f8d07757c68
# Parent  d524d6f54f875c282bd8fea626ceda073cc52cc1
Added missing rights and fixed trigger function.

diff -r d524d6f54f87 -r 1000e0e71d5a schema/auth.sql
--- 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
diff -r d524d6f54f87 -r 1000e0e71d5a schema/gemma.sql
--- 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;