diff options
Diffstat (limited to 'database-versioning/libeufin-bank-drop.sql')
-rw-r--r-- | database-versioning/libeufin-bank-drop.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/database-versioning/libeufin-bank-drop.sql b/database-versioning/libeufin-bank-drop.sql index 52ef772b..2b120b24 100644 --- a/database-versioning/libeufin-bank-drop.sql +++ b/database-versioning/libeufin-bank-drop.sql @@ -5,12 +5,14 @@ $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; + IF EXISTS(SELECT 1 FROM information_schema.schemata WHERE schema_name='_v') THEN + FOR patch IN SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_bank_%' LOOP + PERFORM _v.unregister_patch(patch); + END LOOP; + END IF; END $do$; -DROP SCHEMA libeufin_bank CASCADE; +DROP SCHEMA IF EXISTS libeufin_bank CASCADE; COMMIT; |