diff options
| -rw-r--r-- | src/exchangedb/exchange_do_trigger_kyc_rule_for_account.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/exchangedb/exchange_do_trigger_kyc_rule_for_account.sql b/src/exchangedb/exchange_do_trigger_kyc_rule_for_account.sql index 707b2c718..4d9fa79b0 100644 --- a/src/exchangedb/exchange_do_trigger_kyc_rule_for_account.sql +++ b/src/exchangedb/exchange_do_trigger_kyc_rule_for_account.sql @@ -90,6 +90,7 @@ THEN out_bad_kyc_auth = FALSE; END IF; END IF; + -- First check if a perfectly equivalent legi measure -- already exists, to avoid creating tons of duplicates. UPDATE legitimization_measures @@ -116,6 +117,13 @@ THEN legitimization_measure_serial_id INTO out_legitimization_measure_serial_id; + + -- mark all other active measures finished! + UPDATE legitimization_measures + SET is_finished=TRUE + WHERE access_token=my_access_token + AND NOT is_finished + AND legitimization_measure_serial_id != out_legitimization_measure_serial_id; END IF; EXECUTE FORMAT ( |