aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_reserves_in_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/exchange_do_reserves_in_insert.sql')
-rw-r--r--src/exchangedb/exchange_do_reserves_in_insert.sql11
1 files 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
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);