diff options
Diffstat (limited to 'database-versioning/libeufin-bank-drop.sql')
| -rw-r--r-- | database-versioning/libeufin-bank-drop.sql | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/database-versioning/libeufin-bank-drop.sql b/database-versioning/libeufin-bank-drop.sql index 7fbcc342..52ef772b 100644 --- a/database-versioning/libeufin-bank-drop.sql +++ b/database-versioning/libeufin-bank-drop.sql @@ -1,11 +1,16 @@ BEGIN; --- NOTE: The following unregistration would affect the --- legacy database schema too. That's acceptable as the --- legacy schema is being removed. -SELECT _v.unregister_patch('libeufin-bank-0001'); -SELECT _v.unregister_patch('libeufin-bank-0002'); -SELECT _v.unregister_patch('libeufin-bank-0003'); +DO +$do$ +DECLARE + patch text; +BEGIN + for patch in SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_bank_%' loop + PERFORM _v.unregister_patch(patch); + end loop; +END +$do$; + DROP SCHEMA libeufin_bank CASCADE; COMMIT; |