changeset 5542:0acb06fc77e6 aggregate-gm-import-logging

WIP: close the cursor.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 26 Oct 2021 02:04:29 +0200
parents 29804c8e817d
children 1fcfdf659f52
files schema/updates/1469/aggregate-gm-logs.sql
diffstat 1 files changed, 2 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1469/aggregate-gm-logs.sql	Tue Oct 26 02:02:23 2021 +0200
+++ b/schema/updates/1469/aggregate-gm-logs.sql	Tue Oct 26 02:04:29 2021 +0200
@@ -283,6 +283,8 @@
     last_time := line.time;
   END LOOP;
 
+  CLOSE logs;
+
   -- DELETE FROM import.import_logs WHERE import_id IN (
   --  SELECT id FROM import.imports WHERE kind = 'gm')