summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/syncdb/drop.sql10
1 files changed, 8 insertions, 2 deletions
diff --git a/src/syncdb/drop.sql b/src/syncdb/drop.sql
index 05d11b4..aeaa102 100644
--- a/src/syncdb/drop.sql
+++ b/src/syncdb/drop.sql
@@ -17,8 +17,14 @@
-- Everything in one big transaction
BEGIN;
--- Unregister patch (0001.sql)
-SELECT _v.unregister_patch('sync-0001');
+WITH xpatches AS (
+ SELECT patch_name
+ FROM _v.patches
+ WHERE starts_with(patch_name,'sync-')
+)
+ SELECT _v.unregister_patch(xpatches.patch_name)
+ FROM xpatches;
+
DROP SCHEMA sync CASCADE;
-- And we're out of here...