Mercurial > gemma

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default
author Sascha Wilde <wilde@intevation.de>
date Thu, 01 Aug 2019 17:07:01 +0200
parents 692aba3e8b85 52f7264265bb
children ec8438712447
comparison
equal deleted inserted replaced
4120:ad0c373dff6a 4127:8c62809ea87e
881 $$ 881 $$
882 DECLARE 882 DECLARE
883 tmp RECORD; 883 tmp RECORD;
884 BEGIN 884 BEGIN
885 FOR tmp IN 885 FOR tmp IN
886 SELECT * FROM import.track_imports WHERE import_id = imp_id AND NOT deletion 886 SELECT relation, array_agg(key) AS keys
887 FROM import.track_imports
888 WHERE import_id = imp_id AND NOT deletion
889 GROUP BY relation
887 LOOP 890 LOOP
888 EXECUTE format('DELETE FROM %s WHERE id = $1', tmp.relation) USING tmp.key; 891 EXECUTE format('DELETE FROM %s WHERE id = ANY($1)', tmp.relation)
892 USING tmp.keys;
889 END LOOP; 893 END LOOP;
890 END; 894 END;
891 $$ 895 $$
892 LANGUAGE plpgsql; 896 LANGUAGE plpgsql;
893 897