diff options
Diffstat (limited to 'src/exchangedb/drop.sql')
-rw-r--r-- | src/exchangedb/drop.sql | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/src/exchangedb/drop.sql b/src/exchangedb/drop.sql index ecebde6f5..b7583f794 100644 --- a/src/exchangedb/drop.sql +++ b/src/exchangedb/drop.sql @@ -17,10 +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'); -SELECT _v.unregister_patch('exchange-0002'); -SELECT _v.unregister_patch('exchange-0003'); + +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; |