aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_extensions/sql/test_extensions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/modules/test_extensions/sql/test_extensions.sql')
-rw-r--r--src/test/modules/test_extensions/sql/test_extensions.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/src/test/modules/test_extensions/sql/test_extensions.sql b/src/test/modules/test_extensions/sql/test_extensions.sql
index 51327cc3217..c5b64f47c6b 100644
--- a/src/test/modules/test_extensions/sql/test_extensions.sql
+++ b/src/test/modules/test_extensions/sql/test_extensions.sql
@@ -67,6 +67,19 @@ end';
-- dropping it should still work
drop extension test_ext8;
+-- check handling of types as extension members
+create extension test_ext9;
+\dx+ test_ext9
+alter extension test_ext9 drop type varbitrange;
+\dx+ test_ext9
+alter extension test_ext9 add type varbitrange;
+\dx+ test_ext9
+alter extension test_ext9 drop table sometable;
+\dx+ test_ext9
+alter extension test_ext9 add table sometable;
+\dx+ test_ext9
+drop extension test_ext9;
+
-- Test creation of extension in temporary schema with two-phase commit,
-- which should not work. This function wrapper is useful for portability.