commit 1e7e0058e85e7399ff39e1fc9eaa4316afd5b91c parent 7212cd12bc1ac962b59c9542b28e7c2b55f2d171 Author: Christian Grothoff <christian@grothoff.org> Date: Wed, 28 Dec 2022 12:41:49 +0100 handle idempotency on purse deletion Diffstat:
| M | 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 @@ -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