diff schema/gemma.sql @ 4127:8c62809ea87e request_hist_bns

Merged default
author Sascha Wilde <wilde@intevation.de>
date Thu, 01 Aug 2019 17:07:01 +0200
parents 692aba3e8b85 52f7264265bb
children ec8438712447
line wrap: on
line diff
--- a/schema/gemma.sql	Wed Jul 31 19:08:53 2019 +0200
+++ b/schema/gemma.sql	Thu Aug 01 17:07:01 2019 +0200
@@ -883,9 +883,13 @@
     tmp RECORD;
 BEGIN
     FOR tmp IN
-        SELECT * FROM import.track_imports WHERE import_id = imp_id AND NOT deletion
+        SELECT relation, array_agg(key) AS keys
+            FROM import.track_imports
+            WHERE import_id = imp_id AND NOT deletion
+            GROUP BY relation
     LOOP
-        EXECUTE format('DELETE FROM %s WHERE id = $1', tmp.relation) USING tmp.key;
+        EXECUTE format('DELETE FROM %s WHERE id = ANY($1)', tmp.relation)
+            USING tmp.keys;
     END LOOP;
 END;
 $$