exchange

commit 89c5a3eca927deb57dff2a093e1f0e27b279eb87
parent 53157062cb482824b4315aaa60bb548b2977ced2
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sat, 22 Apr 2023 01:53:41 +0200

-misc bugs

Diffstat:
M
src/exchangedb/exchange_do_reserves_in_insert.sql
 | 
11
++++++++---

1 file changed, 8 insertions(+), 3 deletions(-)
diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql b/src/exchangedb/exchange_do_reserves_in_insert.sql
@@ -786,8 +786,13 @@ BEGIN
       ,in_reserve_expiration
       ,in_gc_date)
     ON CONFLICT DO NOTHING
-    RETURNING reserve_uuid,reserve_pub)
-  SELECT reserve_uuid, reserve_pub FROM reserve_changes;
+    RETURNING
+       reserve_uuid
+      ,reserve_pub)
+  SELECT
+     reserve_uuid
+    ,reserve_pub
+  FROM reserve_changes;
 
   k=0;
   <<loop_reserve>> LOOP
@@ -1016,7 +1021,7 @@ BEGIN
           k = k + 1;
           IF in5_reserve_pub = i.reserve_pub
           THEN
-            transaction_duplicate2 = FALSE;
+            transaction_duplicate5 = FALSE;
             EXECUTE FORMAT (
                'NOTIFY %s'
               ,in5_notify);