aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_batch_reserves_in_insert.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-02-05 20:13:40 +0100
committerChristian Grothoff <christian@grothoff.org>2023-02-05 20:13:40 +0100
commit64b2bc455845022001dd26923df0477eebdf3a86 (patch)
treee4936afbe7481a4fd58f5b9f39c08bdafeeeda2f /src/exchangedb/exchange_do_batch_reserves_in_insert.sql
parentab03ba16e9bc63eb5384e7b6b590fc029bf61152 (diff)
downloadexchange-64b2bc455845022001dd26923df0477eebdf3a86.tar.xz
-fix FTBFS of exchange test
Diffstat (limited to 'src/exchangedb/exchange_do_batch_reserves_in_insert.sql')
-rw-r--r--src/exchangedb/exchange_do_batch_reserves_in_insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/exchangedb/exchange_do_batch_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch_reserves_in_insert.sql
index c95f75c3c..73947b4b9 100644
--- a/src/exchangedb/exchange_do_batch_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_batch_reserves_in_insert.sql
@@ -80,7 +80,6 @@ transaction_duplicate= TRUE;
END IF;
CLOSE curs;
- PERFORM pg_notify(in_notify, NULL);
OPEN curs_trans FOR
WITH reserve_transaction AS(
INSERT INTO reserves_in
@@ -109,6 +108,7 @@ transaction_duplicate= TRUE;
THEN
-- HAPPY PATH THERE IS NO DUPLICATE TRANS
transaction_duplicate = FALSE;
+ PERFORM pg_notify(in_notify, NULL);
END IF;
END IF;
CLOSE curs_trans;