aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
diff options
context:
space:
mode:
authorJoseph <Joseph.xu@efrei.net>2023-01-04 09:43:47 -0500
committerJoseph <Joseph.xu@efrei.net>2023-01-04 09:43:47 -0500
commit069708205c0b14e311f8916788275b121cae2c0e (patch)
tree9abfc8810da5778c54404e68a5251a1f45d67907 /src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
parent2eb59d9135734b614509adc16fdb0f061d05634a (diff)
downloadexchange-069708205c0b14e311f8916788275b121cae2c0e.tar.xz
some modifications for batch_test
Diffstat (limited to 'src/exchangedb/exchange_do_batch4_reserves_in_insert.sql')
-rw-r--r--src/exchangedb/exchange_do_batch4_reserves_in_insert.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
index e2ab133bd..15d8ef6ff 100644
--- a/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_batch4_reserves_in_insert.sql
@@ -249,16 +249,17 @@ BEGIN
END IF;
k=k+1;
END LOOP;
-/* IF transaction_duplicate
+
+ IF transaction_duplicate
OR transaction_duplicate2
OR transaction_duplicate3
OR transaction_duplicate4
THEN
RAISE EXCEPTION 'Reserve did not exist, but INSERT into reserves_in gave conflict';
-
+ ROLLBACK;
CLOSE curs_transaction_exist;
RETURN;
- END IF;*/
+ END IF;
CLOSE curs_transaction_exist;
RETURN;