exchange

commit 9fc4c7869ea42d902352ca33ea6d48ffce6d9897
parent 2e7ddeac91b66a1fbecb8864591563bde73d2554
Author: Christian Grothoff <christian@grothoff.org>
Date:   Thu, 16 Nov 2023 16:52:38 +0100

-specify conflict condition

Diffstat:
M
src/exchangedb/pg_trigger_aml_process.c
 | 
6
+++---

1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/exchangedb/pg_trigger_aml_process.c b/src/exchangedb/pg_trigger_aml_process.c
@@ -46,9 +46,9 @@ TEH_PG_trigger_aml_process (
            "(h_payto"
            ",threshold"
            ",status)"
-           "VALUES"
-           "($1, $2, 1)" // 1: decision needed
-           " ON CONFLICT DO"
+           " VALUES"
+           " ($1, $2, 1)" // 1: decision needed
+           " ON CONFLICT (h_payto) DO"
            " UPDATE SET"
            "   threshold=$2"
            "  ,status=status | 1;"); // do not clear 'frozen' status