summaryrefslogtreecommitdiff
path: root/src/exchangedb/drop.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/drop.sql')
-rw-r--r--src/exchangedb/drop.sql16
1 files changed, 15 insertions, 1 deletions
diff --git a/src/exchangedb/drop.sql b/src/exchangedb/drop.sql
index 4a4dafb1e..b7583f794 100644
--- a/src/exchangedb/drop.sql
+++ b/src/exchangedb/drop.sql
@@ -17,8 +17,22 @@
-- Everything in one big transaction
BEGIN;
+WITH xpatches AS (
+ SELECT patch_name
+ FROM _v.patches
+ WHERE starts_with(patch_name,'exchange-')
+)
+ SELECT _v.unregister_patch(xpatches.patch_name)
+ FROM xpatches;
-SELECT _v.unregister_patch('exchange-0001');
+
+WITH xpatches AS (
+ SELECT patch_name
+ FROM _v.patches
+ WHERE starts_with(patch_name,'auditor-triggers-')
+)
+ SELECT _v.unregister_patch(xpatches.patch_name)
+ FROM xpatches;
DROP SCHEMA exchange CASCADE;