diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-04-22 01:53:41 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-04-22 01:53:41 +0200 |
| commit | 89c5a3eca927deb57dff2a093e1f0e27b279eb87 (patch) | |
| tree | fa2c4bf67e0b03ec97b709cb786909d70f34538b | |
| parent | 53157062cb482824b4315aaa60bb548b2977ced2 (diff) | |
| download | exchange-89c5a3eca927deb57dff2a093e1f0e27b279eb87.tar.gz exchange-89c5a3eca927deb57dff2a093e1f0e27b279eb87.tar.bz2 exchange-89c5a3eca927deb57dff2a093e1f0e27b279eb87.zip | |
-misc bugs
| -rw-r--r-- | src/exchangedb/exchange_do_reserves_in_insert.sql | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql b/src/exchangedb/exchange_do_reserves_in_insert.sql index 1c99f4fd1..77672f012 100644 --- a/src/exchangedb/exchange_do_reserves_in_insert.sql +++ b/src/exchangedb/exchange_do_reserves_in_insert.sql @@ -786,8 +786,13 @@ BEGIN ,in_reserve_expiration ,in_gc_date) ON CONFLICT DO NOTHING - RETURNING reserve_uuid,reserve_pub) - SELECT reserve_uuid, reserve_pub FROM reserve_changes; + RETURNING + reserve_uuid + ,reserve_pub) + SELECT + reserve_uuid + ,reserve_pub + FROM reserve_changes; k=0; <<loop_reserve>> LOOP @@ -1016,7 +1021,7 @@ BEGIN k = k + 1; IF in5_reserve_pub = i.reserve_pub THEN - transaction_duplicate2 = FALSE; + transaction_duplicate5 = FALSE; EXECUTE FORMAT ( 'NOTIFY %s' ,in5_notify); |