diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-11-16 16:52:38 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-11-16 16:52:38 +0100 |
| commit | 9fc4c7869ea42d902352ca33ea6d48ffce6d9897 (patch) | |
| tree | 2e551f6bd481012b970890ae5cd9e049f69fa843 /src/exchangedb | |
| parent | 2e7ddeac91b66a1fbecb8864591563bde73d2554 (diff) | |
| download | exchange-9fc4c7869ea42d902352ca33ea6d48ffce6d9897.tar.gz exchange-9fc4c7869ea42d902352ca33ea6d48ffce6d9897.tar.bz2 exchange-9fc4c7869ea42d902352ca33ea6d48ffce6d9897.zip | |
-specify conflict condition
Diffstat (limited to 'src/exchangedb')
| -rw-r--r-- | src/exchangedb/pg_trigger_aml_process.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/exchangedb/pg_trigger_aml_process.c b/src/exchangedb/pg_trigger_aml_process.c index a4873ae67..76eaa37c0 100644 --- 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 |