diff options
Diffstat (limited to 'src/test/modules/test_extensions/sql/test_extensions.sql')
| -rw-r--r-- | src/test/modules/test_extensions/sql/test_extensions.sql | 8 |
1 files changed, 8 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 2ab8b599dc2..b53be00c4e3 100644 --- a/src/test/modules/test_extensions/sql/test_extensions.sql +++ b/src/test/modules/test_extensions/sql/test_extensions.sql @@ -17,3 +17,11 @@ DROP SCHEMA test_ext CASCADE; CREATE EXTENSION test_ext6; DROP EXTENSION test_ext6; CREATE EXTENSION test_ext6; + +-- test dropping of member tables that own extensions: +-- this table will be absorbed into test_ext7 +create table old_table1 (col1 serial primary key); +create extension test_ext7; +\dx+ test_ext7 +alter extension test_ext7 update to '2.0'; +\dx+ test_ext7 |