diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-06-23 11:41:52 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-06-23 11:41:52 +0200 |
| commit | d25dc8b0adb8fa606e8f97185984a623c52819cd (patch) | |
| tree | d44d8c3f0c62544c653a7d299c029132913eb2c7 /src/exchangedb/exchange_do_batch_reserves_update.sql | |
| parent | 720783b66a08a14624f30e8063daf64d25ce3e4c (diff) | |
fix #7870
Diffstat (limited to 'src/exchangedb/exchange_do_batch_reserves_update.sql')
| -rw-r--r-- | src/exchangedb/exchange_do_batch_reserves_update.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/exchangedb/exchange_do_batch_reserves_update.sql b/src/exchangedb/exchange_do_batch_reserves_update.sql index 82b6b84c..915d9556 100644 --- a/src/exchangedb/exchange_do_batch_reserves_update.sql +++ b/src/exchangedb/exchange_do_batch_reserves_update.sql @@ -65,7 +65,9 @@ BEGIN ,expiration_date=GREATEST(expiration_date,in_expiration_date) ,gc_date=GREATEST(gc_date,in_expiration_date) WHERE reserve_pub=in_reserve_pub; - PERFORM pg_notify(in_notify, NULL); + EXECUTE FORMAT ( + 'NOTIFY %s' + in_notify); ELSE out_duplicate = TRUE; END IF; |