summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-02-24 10:16:10 +0100
committerChristian Grothoff <christian@grothoff.org>2022-02-24 10:16:10 +0100
commit10b9023575b14e581cfd952b75039e71488f5a8f (patch)
tree13cc8d6c210e8194e0167502b5acfe53f659ebca
parent5e5004020eb85a82394ac4d8bd83765304ffd8da (diff)
downloadexchange-10b9023575b14e581cfd952b75039e71488f5a8f.tar.gz
exchange-10b9023575b14e581cfd952b75039e71488f5a8f.tar.bz2
exchange-10b9023575b14e581cfd952b75039e71488f5a8f.zip
-on conflict example
-rw-r--r--src/exchangedb/exchange-0001.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index 125f1020d..dad14700f 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -1148,7 +1148,7 @@ INSERT INTO wire_targets
VALUES
(in_h_payto
,in_receiver_wire_account)
-ON CONFLICT (h_payto) DO NOTHING
+ON CONFLICT DO NOTHING -- for CONFLICT ON (h_payto)
RETURNING wire_target_serial_id INTO wtsi;
IF NOT FOUND