summaryrefslogtreecommitdiffstats
path: root/src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql')
-rw-r--r--src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql b/src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql
new file mode 100644
index 0000000..fdd2f35
--- /dev/null
+++ b/src/test/modules/test_extensions/test_ext_evttrig--1.0--2.0.sql
@@ -0,0 +1,7 @@
+/* src/test/modules/test_extensions/test_event_trigger--1.0--2.0.sql */
+-- complain if script is sourced in psql, rather than via ALTER EXTENSION
+\echo Use "ALTER EXTENSION test_event_trigger UPDATE TO '2.0'" to load this file. \quit
+
+-- Test extension upgrade with event trigger.
+ALTER EVENT TRIGGER table_rewrite_trg DISABLE;
+ALTER TABLE t DROP COLUMN id;