diff options
| author | Antoine A <> | 2024-03-16 01:47:47 +0100 |
|---|---|---|
| committer | Antoine A <> | 2024-03-16 01:47:47 +0100 |
| commit | e5e718622da88f8eff5474a3c7092ee51360977e (patch) | |
| tree | 20c6fd42e491655b263b0d7c65467c1c8bc57750 /database-versioning/libeufin-nexus-drop.sql | |
| parent | e121d549fcc02efe00350ab4fe01a22220d9f149 (diff) | |
| download | libeufin-e5e718622da88f8eff5474a3c7092ee51360977e.tar.gz libeufin-e5e718622da88f8eff5474a3c7092ee51360977e.tar.bz2 libeufin-e5e718622da88f8eff5474a3c7092ee51360977e.zip | |
Fix drop and account soft delete
Diffstat (limited to 'database-versioning/libeufin-nexus-drop.sql')
| -rw-r--r-- | database-versioning/libeufin-nexus-drop.sql | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/database-versioning/libeufin-nexus-drop.sql b/database-versioning/libeufin-nexus-drop.sql index 77ac722a..199f1cb9 100644 --- a/database-versioning/libeufin-nexus-drop.sql +++ b/database-versioning/libeufin-nexus-drop.sql @@ -1,7 +1,15 @@ BEGIN; -SELECT _v.unregister_patch('libeufin-nexus-0001'); -SELECT _v.unregister_patch('libeufin-nexus-0002'); +DO +$do$ +DECLARE + patch text; +BEGIN + for patch in SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_nexus_%' loop + PERFORM _v.unregister_patch(patch); + end loop; +END +$do$; DROP SCHEMA libeufin_nexus CASCADE; COMMIT; |