diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out	2025-04-01 14:48:14.396692000 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out	2025-04-01 14:54:31.313045400 +0000
@@ -144,527 +144,10 @@
   ') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop;
   raise log ''test_extensions looped % times'', c;
 end';
--- extension should now contain no temp objects
-\dx+ test_ext8
-Objects in extension "test_ext8"
-     Object description     
-----------------------------
- function ext8_even(posint)
- table ext8_table1
- type ext8_table1
- type ext8_table1[]
- type posint
- type posint[]
-(6 rows)
-
--- dropping it should still work
-drop extension test_ext8;
--- check handling of types as extension members
-create extension test_ext9;
-\dx+ test_ext9
-          Objects in extension "test_ext9"
-                 Object description                 
-----------------------------------------------------
- cast from varbitrange to varbitmultirange
- function varbitmultirange()
- function varbitmultirange(varbitrange)
- function varbitmultirange(varbitrange[])
- function varbitrange(bit varying,bit varying)
- function varbitrange(bit varying,bit varying,text)
- table sometable
- type somecomposite
- type somecomposite[]
- type sometable
- type sometable[]
- type varbitmultirange
- type varbitmultirange[]
- type varbitrange
- type varbitrange[]
-(15 rows)
-
-alter extension test_ext9 drop type varbitrange;
-\dx+ test_ext9
-          Objects in extension "test_ext9"
-                 Object description                 
-----------------------------------------------------
- cast from varbitrange to varbitmultirange
- function varbitmultirange()
- function varbitmultirange(varbitrange)
- function varbitmultirange(varbitrange[])
- function varbitrange(bit varying,bit varying)
- function varbitrange(bit varying,bit varying,text)
- table sometable
- type somecomposite
- type somecomposite[]
- type sometable
- type sometable[]
-(11 rows)
-
-alter extension test_ext9 add type varbitrange;
-\dx+ test_ext9
-          Objects in extension "test_ext9"
-                 Object description                 
-----------------------------------------------------
- cast from varbitrange to varbitmultirange
- function varbitmultirange()
- function varbitmultirange(varbitrange)
- function varbitmultirange(varbitrange[])
- function varbitrange(bit varying,bit varying)
- function varbitrange(bit varying,bit varying,text)
- table sometable
- type somecomposite
- type somecomposite[]
- type sometable
- type sometable[]
- type varbitmultirange
- type varbitmultirange[]
- type varbitrange
- type varbitrange[]
-(15 rows)
-
-alter extension test_ext9 drop table sometable;
-\dx+ test_ext9
-          Objects in extension "test_ext9"
-                 Object description                 
-----------------------------------------------------
- cast from varbitrange to varbitmultirange
- function varbitmultirange()
- function varbitmultirange(varbitrange)
- function varbitmultirange(varbitrange[])
- function varbitrange(bit varying,bit varying)
- function varbitrange(bit varying,bit varying,text)
- type somecomposite
- type somecomposite[]
- type varbitmultirange
- type varbitmultirange[]
- type varbitrange
- type varbitrange[]
-(12 rows)
-
-alter extension test_ext9 add table sometable;
-\dx+ test_ext9
-          Objects in extension "test_ext9"
-                 Object description                 
-----------------------------------------------------
- cast from varbitrange to varbitmultirange
- function varbitmultirange()
- function varbitmultirange(varbitrange)
- function varbitmultirange(varbitrange[])
- function varbitrange(bit varying,bit varying)
- function varbitrange(bit varying,bit varying,text)
- table sometable
- type somecomposite
- type somecomposite[]
- type sometable
- type sometable[]
- type varbitmultirange
- type varbitmultirange[]
- type varbitrange
- type varbitrange[]
-(15 rows)
-
-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.
--- Avoid noise caused by CONTEXT and NOTICE messages including the temporary
--- schema name.
-\set SHOW_CONTEXT never
-SET client_min_messages TO 'warning';
--- First enforce presence of temporary schema.
-CREATE TEMP TABLE test_ext4_tab ();
-CREATE OR REPLACE FUNCTION create_extension_with_temp_schema()
-  RETURNS VOID AS $$
-  DECLARE
-    tmpschema text;
-    query text;
-  BEGIN
-    SELECT INTO tmpschema pg_my_temp_schema()::regnamespace;
-    query := 'CREATE EXTENSION test_ext4 SCHEMA ' || tmpschema || ' CASCADE;';
-    RAISE NOTICE 'query %', query;
-    EXECUTE query;
-  END; $$ LANGUAGE plpgsql;
-BEGIN;
-SELECT create_extension_with_temp_schema();
- create_extension_with_temp_schema 
------------------------------------
- 
-(1 row)
-
-PREPARE TRANSACTION 'twophase_extension';
-ERROR:  cannot PREPARE a transaction that has operated on temporary objects
--- Clean up
-DROP TABLE test_ext4_tab;
-DROP FUNCTION create_extension_with_temp_schema();
-RESET client_min_messages;
-\unset SHOW_CONTEXT
--- Test case of an event trigger run in an extension upgrade script.
--- See: https://postgr.es/m/20200902193715.6e0269d4@firost
-CREATE EXTENSION test_ext_evttrig;
-ALTER EXTENSION test_ext_evttrig UPDATE TO '2.0';
-DROP EXTENSION test_ext_evttrig;
--- It's generally bad style to use CREATE OR REPLACE unnecessarily.
--- Test what happens if an extension does it anyway.
--- Replacing a shell type or operator is sort of like CREATE OR REPLACE;
--- check that too.
-CREATE FUNCTION ext_cor_func() RETURNS text
-  AS $$ SELECT 'ext_cor_func: original'::text $$ LANGUAGE sql;
-CREATE EXTENSION test_ext_cor;  -- fail
-ERROR:  function ext_cor_func() is not a member of extension "test_ext_cor"
-DETAIL:  An extension is not allowed to replace an object that it does not own.
-CONTEXT:  SQL statement "CREATE OR REPLACE FUNCTION ext_cor_func() RETURNS text
-  AS $$ SELECT 'ext_cor_func: from extension'::text $$ LANGUAGE sql"
-extension script file "test_ext_cor--1.0.sql", near line 8
-SELECT ext_cor_func();
-      ext_cor_func      
-------------------------
- ext_cor_func: original
-(1 row)
-
-DROP FUNCTION ext_cor_func();
-CREATE VIEW ext_cor_view AS
-  SELECT 'ext_cor_view: original'::text AS col;
-CREATE EXTENSION test_ext_cor;  -- fail
-ERROR:  view ext_cor_view is not a member of extension "test_ext_cor"
-DETAIL:  An extension is not allowed to replace an object that it does not own.
-CONTEXT:  SQL statement "CREATE OR REPLACE VIEW ext_cor_view AS
-  SELECT 'ext_cor_view: from extension'::text AS col"
-extension script file "test_ext_cor--1.0.sql", near line 11
-SELECT ext_cor_func();
-ERROR:  function ext_cor_func() does not exist
-LINE 1: SELECT ext_cor_func();
-               ^
-HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
-SELECT * FROM ext_cor_view;
-          col           
-------------------------
- ext_cor_view: original
-(1 row)
-
-DROP VIEW ext_cor_view;
-CREATE TYPE test_ext_type;
-CREATE EXTENSION test_ext_cor;  -- fail
-ERROR:  type test_ext_type is not a member of extension "test_ext_cor"
-DETAIL:  An extension is not allowed to replace an object that it does not own.
-CONTEXT:  SQL statement "CREATE TYPE test_ext_type AS ENUM('x', 'y')"
-extension script file "test_ext_cor--1.0.sql", near line 17
-DROP TYPE test_ext_type;
--- this makes a shell "point <<@@ polygon" operator too
-CREATE OPERATOR @@>> ( PROCEDURE = poly_contain_pt,
-  LEFTARG = polygon, RIGHTARG = point,
-  COMMUTATOR = <<@@ );
-CREATE EXTENSION test_ext_cor;  -- fail
-ERROR:  operator <<@@(point,polygon) is not a member of extension "test_ext_cor"
-DETAIL:  An extension is not allowed to replace an object that it does not own.
-CONTEXT:  SQL statement "CREATE OPERATOR <<@@ ( PROCEDURE = pt_contained_poly,
-  LEFTARG = point, RIGHTARG = polygon )"
-extension script file "test_ext_cor--1.0.sql", near line 19
-DROP OPERATOR <<@@ (point, polygon);
-CREATE EXTENSION test_ext_cor;  -- now it should work
-SELECT ext_cor_func();
-         ext_cor_func         
-------------------------------
- ext_cor_func: from extension
-(1 row)
-
-SELECT * FROM ext_cor_view;
-             col              
-------------------------------
- ext_cor_view: from extension
-(1 row)
-
-SELECT 'x'::test_ext_type;
- test_ext_type 
----------------
- x
-(1 row)
-
-SELECT point(0,0) <<@@ polygon(circle(point(0,0),1));
- ?column? 
-----------
- t
-(1 row)
-
-\dx+ test_ext_cor
-Objects in extension "test_ext_cor"
-      Object description      
-------------------------------
- function ext_cor_func()
- operator <<@@(point,polygon)
- type ext_cor_view
- type ext_cor_view[]
- type test_ext_type
- type test_ext_type[]
- view ext_cor_view
-(7 rows)
-
---
--- CREATE IF NOT EXISTS is an entirely unsound thing for an extension
--- to be doing, but let's at least plug the major security hole in it.
---
-CREATE COLLATION ext_cine_coll
-  ( LC_COLLATE = "C", LC_CTYPE = "C" );
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  collation ext_cine_coll is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE COLLATION IF NOT EXISTS ext_cine_coll
-  ( LC_COLLATE = "POSIX", LC_CTYPE = "POSIX" )"
-extension script file "test_ext_cine--1.0.sql", near line 10
-DROP COLLATION ext_cine_coll;
-CREATE MATERIALIZED VIEW ext_cine_mv AS SELECT 11 AS f1;
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  materialized view ext_cine_mv is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE MATERIALIZED VIEW IF NOT EXISTS ext_cine_mv AS SELECT 42 AS f1"
-extension script file "test_ext_cine--1.0.sql", near line 13
-DROP MATERIALIZED VIEW ext_cine_mv;
-CREATE FOREIGN DATA WRAPPER dummy;
-CREATE SERVER ext_cine_srv FOREIGN DATA WRAPPER dummy;
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  server ext_cine_srv is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE SERVER IF NOT EXISTS ext_cine_srv FOREIGN DATA WRAPPER ext_cine_fdw"
-extension script file "test_ext_cine--1.0.sql", near line 17
-DROP SERVER ext_cine_srv;
-CREATE SCHEMA ext_cine_schema;
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  schema ext_cine_schema is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE SCHEMA IF NOT EXISTS ext_cine_schema"
-extension script file "test_ext_cine--1.0.sql", near line 19
-DROP SCHEMA ext_cine_schema;
-CREATE SEQUENCE ext_cine_seq;
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  sequence ext_cine_seq is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE SEQUENCE IF NOT EXISTS ext_cine_seq"
-extension script file "test_ext_cine--1.0.sql", near line 21
-DROP SEQUENCE ext_cine_seq;
-CREATE TABLE ext_cine_tab1 (x int);
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  table ext_cine_tab1 is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE TABLE IF NOT EXISTS ext_cine_tab1 (x int)"
-extension script file "test_ext_cine--1.0.sql", near line 23
-DROP TABLE ext_cine_tab1;
-CREATE TABLE ext_cine_tab2 AS SELECT 42 AS y;
-CREATE EXTENSION test_ext_cine;  -- fail
-ERROR:  table ext_cine_tab2 is not a member of extension "test_ext_cine"
-DETAIL:  An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.
-CONTEXT:  SQL statement "CREATE TABLE IF NOT EXISTS ext_cine_tab2 AS SELECT 42 AS y"
-extension script file "test_ext_cine--1.0.sql", near line 25
-DROP TABLE ext_cine_tab2;
-CREATE EXTENSION test_ext_cine;
-\dx+ test_ext_cine
-Objects in extension "test_ext_cine"
-        Object description         
------------------------------------
- collation ext_cine_coll
- foreign-data wrapper ext_cine_fdw
- materialized view ext_cine_mv
- schema ext_cine_schema
- sequence ext_cine_seq
- server ext_cine_srv
- table ext_cine_tab1
- table ext_cine_tab2
- type ext_cine_mv
- type ext_cine_mv[]
- type ext_cine_tab1
- type ext_cine_tab1[]
- type ext_cine_tab2
- type ext_cine_tab2[]
-(14 rows)
-
-ALTER EXTENSION test_ext_cine UPDATE TO '1.1';
-\dx+ test_ext_cine
-Objects in extension "test_ext_cine"
-        Object description         
------------------------------------
- collation ext_cine_coll
- foreign-data wrapper ext_cine_fdw
- materialized view ext_cine_mv
- schema ext_cine_schema
- sequence ext_cine_seq
- server ext_cine_srv
- table ext_cine_tab1
- table ext_cine_tab2
- table ext_cine_tab3
- type ext_cine_mv
- type ext_cine_mv[]
- type ext_cine_tab1
- type ext_cine_tab1[]
- type ext_cine_tab2
- type ext_cine_tab2[]
- type ext_cine_tab3
- type ext_cine_tab3[]
-(17 rows)
-
---
--- Test @extschema@ syntax.
---
-CREATE SCHEMA "has space";
-CREATE EXTENSION test_ext_extschema SCHEMA has$dollar;
-ERROR:  invalid character in extension "test_ext_extschema" schema: must not contain any of ""$'\"
-CREATE EXTENSION test_ext_extschema SCHEMA "has space";
---
--- Test basic SET SCHEMA handling.
---
-CREATE SCHEMA s1;
-CREATE SCHEMA s2;
-CREATE EXTENSION test_ext_set_schema SCHEMA s1;
-ALTER EXTENSION test_ext_set_schema SET SCHEMA s2;
-\dx+ test_ext_set_schema
-      Objects in extension "test_ext_set_schema"
-                  Object description                   
--------------------------------------------------------
- cast from s2.ess_range_type to s2.ess_multirange_type
- function s2.ess_func(integer)
- function s2.ess_multirange_type()
- function s2.ess_multirange_type(s2.ess_range_type)
- function s2.ess_multirange_type(s2.ess_range_type[])
- function s2.ess_range_type(text,text)
- function s2.ess_range_type(text,text,text)
- table s2.ess_table
- type s2.ess_composite_type
- type s2.ess_composite_type[]
- type s2.ess_multirange_type
- type s2.ess_multirange_type[]
- type s2.ess_range_type
- type s2.ess_range_type[]
- type s2.ess_table
- type s2.ess_table[]
-(16 rows)
-
-\sf s2.ess_func(int)
-CREATE OR REPLACE FUNCTION s2.ess_func(integer)
- RETURNS text
- LANGUAGE sql
-BEGIN ATOMIC
- SELECT ess_table.f3
-    FROM s2.ess_table
-   WHERE (ess_table.f1 = $1);
-END
---
--- Test extension with objects outside the extension's schema.
---
-CREATE SCHEMA test_func_dep1;
-CREATE SCHEMA test_func_dep2;
-CREATE SCHEMA test_func_dep3;
-CREATE EXTENSION test_ext_req_schema1 SCHEMA test_func_dep1;
-ALTER FUNCTION test_func_dep1.dep_req1() SET SCHEMA test_func_dep2;
-SELECT pg_describe_object(classid, objid, objsubid) as obj,
-       pg_describe_object(refclassid, refobjid, refobjsubid) as objref,
-       deptype
-  FROM pg_depend
-  WHERE classid = 'pg_extension'::regclass AND
-        objid = (SELECT oid FROM pg_extension WHERE extname = 'test_ext_req_schema1')
-  ORDER BY 1, 2;
-              obj               |        objref         | deptype 
---------------------------------+-----------------------+---------
- extension test_ext_req_schema1 | schema test_func_dep1 | n
-(1 row)
-
--- fails, as function dep_req1 is not in the same schema as the extension.
-ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_func_dep3;
-ERROR:  extension "test_ext_req_schema1" does not support SET SCHEMA
-DETAIL:  function test_func_dep2.dep_req1() is not in the extension's schema "test_func_dep1"
--- Move back the function, and the extension can be moved.
-ALTER FUNCTION test_func_dep2.dep_req1() SET SCHEMA test_func_dep1;
-ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_func_dep3;
-SELECT pg_describe_object(classid, objid, objsubid) as obj,
-       pg_describe_object(refclassid, refobjid, refobjsubid) as objref,
-       deptype
-  FROM pg_depend
-  WHERE classid = 'pg_extension'::regclass AND
-        objid = (SELECT oid FROM pg_extension WHERE extname = 'test_ext_req_schema1')
-  ORDER BY 1, 2;
-              obj               |        objref         | deptype 
---------------------------------+-----------------------+---------
- extension test_ext_req_schema1 | schema test_func_dep3 | n
-(1 row)
-
-DROP EXTENSION test_ext_req_schema1 CASCADE;
-DROP SCHEMA test_func_dep1;
-DROP SCHEMA test_func_dep2;
-DROP SCHEMA test_func_dep3;
---
--- Test @extschema:extname@ syntax and no_relocate option
---
-CREATE EXTENSION test_ext_req_schema1 SCHEMA has$dollar;
-CREATE EXTENSION test_ext_req_schema3 CASCADE;
-NOTICE:  installing required extension "test_ext_req_schema2"
-ERROR:  invalid character in extension "test_ext_req_schema1" schema: must not contain any of ""$'\"
-DROP EXTENSION test_ext_req_schema1;
-CREATE SCHEMA test_s_dep;
-CREATE EXTENSION test_ext_req_schema1 SCHEMA test_s_dep;
-CREATE EXTENSION test_ext_req_schema3 CASCADE;
-NOTICE:  installing required extension "test_ext_req_schema2"
-SELECT test_s_dep.dep_req1();
- dep_req1 
-----------
- req1
-(1 row)
-
-SELECT dep_req2();
- dep_req2  
------------
- req1 req2
-(1 row)
-
-SELECT dep_req3();
- dep_req3  
------------
- req1 req3
-(1 row)
-
-SELECT dep_req3b();
-    dep_req3b    
------------------
- req1 req2 req3b
-(1 row)
-
-CREATE SCHEMA test_s_dep2;
-ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_s_dep2;  -- fails
-ERROR:  cannot SET SCHEMA of extension "test_ext_req_schema1" because other extensions prevent it
-DETAIL:  Extension "test_ext_req_schema3" requests no relocation of extension "test_ext_req_schema1".
-ALTER EXTENSION test_ext_req_schema2 SET SCHEMA test_s_dep;  -- allowed
-SELECT test_s_dep.dep_req1();
- dep_req1 
-----------
- req1
-(1 row)
-
-SELECT test_s_dep.dep_req2();
- dep_req2  
------------
- req1 req2
-(1 row)
-
-SELECT dep_req3();
- dep_req3  
------------
- req1 req3
-(1 row)
-
-SELECT dep_req3b();  -- fails
-ERROR:  function public.dep_req2() does not exist
-LINE 1:  SELECT public.dep_req2() || ' req3b' 
-                ^
-HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
-QUERY:   SELECT public.dep_req2() || ' req3b' 
-CONTEXT:  SQL function "dep_req3b" during startup
-DROP EXTENSION test_ext_req_schema3;
-ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_s_dep2;  -- now ok
-SELECT test_s_dep2.dep_req1();
- dep_req1 
-----------
- req1
-(1 row)
-
-SELECT test_s_dep.dep_req2();
- dep_req2  
------------
- req1 req2
-(1 row)
-
-DROP EXTENSION test_ext_req_schema1 CASCADE;
-NOTICE:  drop cascades to extension test_ext_req_schema2
+WARNING:  terminating connection because of crash of another server process
+DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
+HINT:  In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+	This probably means the server terminated abnormally
+	before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extdepend.out C:/cirrus/build/testrun/test_extensions/regress/results/test_extdepend.out
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extdepend.out	2025-04-01 14:48:14.396692000 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extdepend.out	2025-04-01 14:54:31.480472100 +0000
@@ -1,188 +1,2 @@
---
--- test ALTER THING name DEPENDS ON EXTENSION
---
--- Common setup for all tests
-CREATE TABLE test_extdep_commands (command text);
-COPY test_extdep_commands FROM stdin;
-SELECT * FROM test_extdep_commands;
-                                 command                                 
--------------------------------------------------------------------------
-  CREATE SCHEMA test_ext
-  CREATE EXTENSION test_ext5 SCHEMA test_ext
-  SET search_path TO test_ext
-  CREATE TABLE a (a1 int)
- 
-  CREATE FUNCTION b() RETURNS TRIGGER LANGUAGE plpgsql AS               +
-    $$ BEGIN NEW.a1 := NEW.a1 + 42; RETURN NEW; END; $$
-  ALTER FUNCTION b() DEPENDS ON EXTENSION test_ext5
- 
-  CREATE TRIGGER c BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE b()
-  ALTER TRIGGER c ON a DEPENDS ON EXTENSION test_ext5
- 
-  CREATE MATERIALIZED VIEW d AS SELECT * FROM a
-  ALTER MATERIALIZED VIEW d DEPENDS ON EXTENSION test_ext5
- 
-  CREATE INDEX e ON a (a1)
-  ALTER INDEX e DEPENDS ON EXTENSION test_ext5
-  RESET search_path
-(17 rows)
-
--- First, test that dependent objects go away when the extension is dropped.
-SELECT * FROM test_extdep_commands \gexec
- CREATE SCHEMA test_ext
- CREATE EXTENSION test_ext5 SCHEMA test_ext
- SET search_path TO test_ext
- CREATE TABLE a (a1 int)
-
- CREATE FUNCTION b() RETURNS TRIGGER LANGUAGE plpgsql AS
-   $$ BEGIN NEW.a1 := NEW.a1 + 42; RETURN NEW; END; $$
- ALTER FUNCTION b() DEPENDS ON EXTENSION test_ext5
-
- CREATE TRIGGER c BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE b()
- ALTER TRIGGER c ON a DEPENDS ON EXTENSION test_ext5
-
- CREATE MATERIALIZED VIEW d AS SELECT * FROM a
- ALTER MATERIALIZED VIEW d DEPENDS ON EXTENSION test_ext5
-
- CREATE INDEX e ON a (a1)
- ALTER INDEX e DEPENDS ON EXTENSION test_ext5
- RESET search_path
--- A dependent object made dependent again has no effect
-ALTER FUNCTION test_ext.b() DEPENDS ON EXTENSION test_ext5;
--- make sure we have the right dependencies on the extension
-SELECT deptype, p.*
-  FROM pg_depend, pg_identify_object(classid, objid, objsubid) AS p
- WHERE refclassid = 'pg_extension'::regclass AND
-       refobjid = (SELECT oid FROM pg_extension WHERE extname = 'test_ext5')
-ORDER BY type;
- deptype |       type        |  schema  | name |    identity     
----------+-------------------+----------+------+-----------------
- x       | function          | test_ext |      | test_ext.b()
- x       | index             | test_ext | e    | test_ext.e
- x       | materialized view | test_ext | d    | test_ext.d
- x       | trigger           |          |      | c on test_ext.a
-(4 rows)
-
-DROP EXTENSION test_ext5;
--- anything still depending on the table?
-SELECT deptype, i.*
-  FROM pg_catalog.pg_depend, pg_identify_object(classid, objid, objsubid) i
-WHERE refclassid='pg_class'::regclass AND
- refobjid='test_ext.a'::regclass AND NOT deptype IN ('i', 'a');
- deptype | type | schema | name | identity 
----------+------+--------+------+----------
-(0 rows)
-
-DROP SCHEMA test_ext CASCADE;
-NOTICE:  drop cascades to table test_ext.a
--- Second test: If we drop the table, the objects are dropped too and no
--- vestige remains in pg_depend.
-SELECT * FROM test_extdep_commands \gexec
- CREATE SCHEMA test_ext
- CREATE EXTENSION test_ext5 SCHEMA test_ext
- SET search_path TO test_ext
- CREATE TABLE a (a1 int)
-
- CREATE FUNCTION b() RETURNS TRIGGER LANGUAGE plpgsql AS
-   $$ BEGIN NEW.a1 := NEW.a1 + 42; RETURN NEW; END; $$
- ALTER FUNCTION b() DEPENDS ON EXTENSION test_ext5
-
- CREATE TRIGGER c BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE b()
- ALTER TRIGGER c ON a DEPENDS ON EXTENSION test_ext5
-
- CREATE MATERIALIZED VIEW d AS SELECT * FROM a
- ALTER MATERIALIZED VIEW d DEPENDS ON EXTENSION test_ext5
-
- CREATE INDEX e ON a (a1)
- ALTER INDEX e DEPENDS ON EXTENSION test_ext5
- RESET search_path
-DROP TABLE test_ext.a;		-- should fail, require cascade
-ERROR:  cannot drop table test_ext.a because other objects depend on it
-DETAIL:  materialized view test_ext.d depends on table test_ext.a
-HINT:  Use DROP ... CASCADE to drop the dependent objects too.
-DROP TABLE test_ext.a CASCADE;
-NOTICE:  drop cascades to materialized view test_ext.d
--- anything still depending on the extension?  Should be only function b()
-SELECT deptype, i.*
-  FROM pg_catalog.pg_depend, pg_identify_object(classid, objid, objsubid) i
- WHERE refclassid='pg_extension'::regclass AND
- refobjid=(SELECT oid FROM pg_extension WHERE extname='test_ext5');
- deptype |   type   |  schema  | name |   identity   
----------+----------+----------+------+--------------
- x       | function | test_ext |      | test_ext.b()
-(1 row)
-
-DROP EXTENSION test_ext5;
-DROP SCHEMA test_ext CASCADE;
--- Third test: we can drop the objects individually
-SELECT * FROM test_extdep_commands \gexec
- CREATE SCHEMA test_ext
- CREATE EXTENSION test_ext5 SCHEMA test_ext
- SET search_path TO test_ext
- CREATE TABLE a (a1 int)
-
- CREATE FUNCTION b() RETURNS TRIGGER LANGUAGE plpgsql AS
-   $$ BEGIN NEW.a1 := NEW.a1 + 42; RETURN NEW; END; $$
- ALTER FUNCTION b() DEPENDS ON EXTENSION test_ext5
-
- CREATE TRIGGER c BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE b()
- ALTER TRIGGER c ON a DEPENDS ON EXTENSION test_ext5
-
- CREATE MATERIALIZED VIEW d AS SELECT * FROM a
- ALTER MATERIALIZED VIEW d DEPENDS ON EXTENSION test_ext5
-
- CREATE INDEX e ON a (a1)
- ALTER INDEX e DEPENDS ON EXTENSION test_ext5
- RESET search_path
-SET search_path TO test_ext;
-DROP TRIGGER c ON a;
-DROP FUNCTION b();
-DROP MATERIALIZED VIEW d;
-DROP INDEX e;
-SELECT deptype, i.*
-  FROM pg_catalog.pg_depend, pg_identify_object(classid, objid, objsubid) i
- WHERE (refclassid='pg_extension'::regclass AND
-        refobjid=(SELECT oid FROM pg_extension WHERE extname='test_ext5'))
-	OR (refclassid='pg_class'::regclass AND refobjid='test_ext.a'::regclass)
-   AND NOT deptype IN ('i', 'a');
- deptype | type | schema | name | identity 
----------+------+--------+------+----------
-(0 rows)
-
-DROP TABLE a;
-RESET search_path;
-DROP SCHEMA test_ext CASCADE;
-NOTICE:  drop cascades to extension test_ext5
--- Fourth test: we can mark the objects as dependent, then unmark; then the
--- drop of the extension does nothing
-SELECT * FROM test_extdep_commands \gexec
- CREATE SCHEMA test_ext
- CREATE EXTENSION test_ext5 SCHEMA test_ext
- SET search_path TO test_ext
- CREATE TABLE a (a1 int)
-
- CREATE FUNCTION b() RETURNS TRIGGER LANGUAGE plpgsql AS
-   $$ BEGIN NEW.a1 := NEW.a1 + 42; RETURN NEW; END; $$
- ALTER FUNCTION b() DEPENDS ON EXTENSION test_ext5
-
- CREATE TRIGGER c BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE b()
- ALTER TRIGGER c ON a DEPENDS ON EXTENSION test_ext5
-
- CREATE MATERIALIZED VIEW d AS SELECT * FROM a
- ALTER MATERIALIZED VIEW d DEPENDS ON EXTENSION test_ext5
-
- CREATE INDEX e ON a (a1)
- ALTER INDEX e DEPENDS ON EXTENSION test_ext5
- RESET search_path
-SET search_path TO test_ext;
-ALTER FUNCTION b() NO DEPENDS ON EXTENSION test_ext5;
-ALTER TRIGGER c ON a NO DEPENDS ON EXTENSION test_ext5;
-ALTER MATERIALIZED VIEW d NO DEPENDS ON EXTENSION test_ext5;
-ALTER INDEX e NO DEPENDS ON EXTENSION test_ext5;
-DROP EXTENSION test_ext5;
-DROP TRIGGER c ON a;
-DROP FUNCTION b();
-DROP MATERIALIZED VIEW d;
-DROP INDEX e;
-DROP SCHEMA test_ext CASCADE;
-NOTICE:  drop cascades to table a
+psql: error: connection to server on socket "c:/cirrus//.s.PGSQL.40067" failed: FATAL:  the database system is not yet accepting connections
+DETAIL:  Consistent recovery state has not been yet reached.