summaryrefslogtreecommitdiff
path: root/src/backenddb/pg_insert_deposit_to_transfer.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/backenddb/pg_insert_deposit_to_transfer.sql')
-rw-r--r--src/backenddb/pg_insert_deposit_to_transfer.sql5
1 files changed, 4 insertions, 1 deletions
diff --git a/src/backenddb/pg_insert_deposit_to_transfer.sql b/src/backenddb/pg_insert_deposit_to_transfer.sql
index ddc291c3..bd3a5943 100644
--- a/src/backenddb/pg_insert_deposit_to_transfer.sql
+++ b/src/backenddb/pg_insert_deposit_to_transfer.sql
@@ -22,7 +22,8 @@ CREATE OR REPLACE FUNCTION merchant_insert_deposit_to_transfer (
IN in_exchange_sig BYTEA,
IN in_exchange_pub BYTEA,
IN in_wtid BYTEA,
- OUT out_wire_pending_cleared BOOL)
+ OUT out_wire_pending_cleared BOOL,
+ OUT out_conflict BOOL)
LANGUAGE plpgsql
AS $$
DECLARE
@@ -51,6 +52,8 @@ INSERT INTO merchant_deposit_to_transfer
AND wtid=in_wtid
ON CONFLICT DO NOTHING;
+out_conflict = NOT FOUND;
+
IF NOT FOUND
THEN
SELECT deposit_confirmation_serial