From 89c5a3eca927deb57dff2a093e1f0e27b279eb87 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 22 Apr 2023 01:53:41 +0200
Subject: -misc bugs

---
 src/exchangedb/exchange_do_reserves_in_insert.sql | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'src/exchangedb/exchange_do_reserves_in_insert.sql')

diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql b/src/exchangedb/exchange_do_reserves_in_insert.sql
index 1c99f4fd1..77672f012 100644
--- 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);
-- 
cgit v1.2.3