diff options
Diffstat (limited to 'src/exchangedb/exchange_do_batch_reserves_in_insert.sql')
| -rw-r--r-- | src/exchangedb/exchange_do_batch_reserves_in_insert.sql | 2 |
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; |