From 1e7e0058e85e7399ff39e1fc9eaa4316afd5b91c Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Wed, 28 Dec 2022 12:41:49 +0100 Subject: handle idempotency on purse deletion --- src/exchangedb/exchange_do_delete_purse.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/src/exchangedb/exchange_do_delete_purse.sql b/src/exchangedb/exchange_do_delete_purse.sql index 3d493e624..1e6540ecf 100644 --- a/src/exchangedb/exchange_do_delete_purse.sql +++ b/src/exchangedb/exchange_do_delete_purse.sql @@ -54,7 +54,13 @@ INSERT INTO purse_deletion ,purse_sig) VALUES (in_purse_pub - ,in_purse_sig); + ,in_purse_sig) +ON CONFLICT DO NOTHING; + +IF NOT FOUND +THEN + RETURN; +END IF; -- store purse decision INSERT INTO purse_decision -- cgit v1.2.3