2024-11-21 04:53:03.930 GMT postmaster[632] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-21 04:53:03.931 GMT postmaster[632] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40066" 2024-11-21 04:53:03.957 GMT startup[5300] LOG: database system was shut down at 2024-11-21 04:53:03 GMT 2024-11-21 04:53:03.962 GMT postmaster[632] LOG: database system is ready to accept connections 2024-11-21 04:53:04.385 GMT client backend[6356] pg_regress/test_extensions ERROR: required extension "test_ext2" is not installed 2024-11-21 04:53:04.385 GMT client backend[6356] pg_regress/test_extensions HINT: Use CREATE EXTENSION ... CASCADE to install required extensions too. 2024-11-21 04:53:04.385 GMT client backend[6356] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext1; 2024-11-21 04:53:04.386 GMT client backend[6356] pg_regress/test_extensions ERROR: schema "test_ext1" does not exist 2024-11-21 04:53:04.386 GMT client backend[6356] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext1 SCHEMA test_ext1; 2024-11-21 04:53:04.386 GMT client backend[6356] pg_regress/test_extensions ERROR: schema "test_ext" does not exist 2024-11-21 04:53:04.386 GMT client backend[6356] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext1 SCHEMA test_ext; 2024-11-21 04:53:04.387 GMT client backend[6356] pg_regress/test_extensions ERROR: extension "test_ext1" must be installed in schema "test_ext1" 2024-11-21 04:53:04.387 GMT client backend[6356] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext1 SCHEMA has$dollar; 2024-11-21 04:53:04.395 GMT client backend[6356] pg_regress/test_extensions ERROR: cyclic dependency detected between extensions "test_ext_cyclic1" and "test_ext_cyclic2" 2024-11-21 04:53:04.395 GMT client backend[6356] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cyclic1 CASCADE; 2024-11-21 04:53:04.457 GMT client backend[6356] pg_regress/test_extensions ERROR: syntax error at or near "FUNCTIN" at character 8 2024-11-21 04:53:04.457 GMT client backend[6356] pg_regress/test_extensions QUERY: CREATE FUNCTIN my_erroneous_func(int) RETURNS int LANGUAGE SQL AS $$ SELECT $1 + 1 $$; 2024-11-21 04:53:04.457 GMT client backend[6356] pg_regress/test_extensions CONTEXT: extension script file "test_ext7--2.0--2.1bad.sql", near line 10 2024-11-21 04:53:04.457 GMT client backend[6356] pg_regress/test_extensions STATEMENT: alter extension test_ext7 update to '2.1bad'; 2024-11-21 04:53:04.458 GMT client backend[6356] pg_regress/test_extensions ERROR: syntax error at or near "," at character 14 2024-11-21 04:53:04.458 GMT client backend[6356] pg_regress/test_extensions QUERY: SELECT $1 + , 1 2024-11-21 04:53:04.458 GMT client backend[6356] pg_regress/test_extensions CONTEXT: SQL statement "CREATE FUNCTION my_erroneous_func(int) RETURNS int LANGUAGE SQL AS $$ SELECT $1 + , 1 $$" extension script file "test_ext7--2.0--2.2bad.sql", near line 9 2024-11-21 04:53:04.458 GMT client backend[6356] pg_regress/test_extensions STATEMENT: alter extension test_ext7 update to '2.2bad'; 2024-11-21 04:53:04.514 GMT client backend[5156] pg_regress/test_extensions LOG: test_extensions looped 0 times 2024-11-21 04:53:04.514 GMT client backend[5156] pg_regress/test_extensions CONTEXT: PL/pgSQL function inline_code_block line 4 at RAISE 2024-11-21 04:53:04.514 GMT client backend[5156] pg_regress/test_extensions STATEMENT: do 'declare c int = 0; begin while (select count(*) from pg_stat_activity where pid = ' '6356' ') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop; raise log ''test_extensions looped % times'', c; end'; 2024-11-21 04:53:04.542 GMT client backend[5156] pg_regress/test_extensions ERROR: cannot PREPARE a transaction that has operated on temporary objects 2024-11-21 04:53:04.542 GMT client backend[5156] pg_regress/test_extensions STATEMENT: PREPARE TRANSACTION 'twophase_extension'; 2024-11-21 04:53:04.570 GMT client backend[5156] pg_regress/test_extensions ERROR: function ext_cor_func() is not a member of extension "test_ext_cor" 2024-11-21 04:53:04.570 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension is not allowed to replace an object that it does not own. 2024-11-21 04:53:04.570 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.570 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cor; 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions ERROR: view ext_cor_view is not a member of extension "test_ext_cor" 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension is not allowed to replace an object that it does not own. 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cor; 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions ERROR: function ext_cor_func() does not exist at character 8 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2024-11-21 04:53:04.574 GMT client backend[5156] pg_regress/test_extensions STATEMENT: SELECT ext_cor_func(); 2024-11-21 04:53:04.577 GMT client backend[5156] pg_regress/test_extensions ERROR: type test_ext_type is not a member of extension "test_ext_cor" 2024-11-21 04:53:04.577 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension is not allowed to replace an object that it does not own. 2024-11-21 04:53:04.577 GMT client backend[5156] pg_regress/test_extensions CONTEXT: SQL statement "CREATE TYPE test_ext_type AS ENUM('x', 'y')" extension script file "test_ext_cor--1.0.sql", near line 17 2024-11-21 04:53:04.577 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cor; 2024-11-21 04:53:04.580 GMT client backend[5156] pg_regress/test_extensions ERROR: operator <<@@(point,polygon) is not a member of extension "test_ext_cor" 2024-11-21 04:53:04.580 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension is not allowed to replace an object that it does not own. 2024-11-21 04:53:04.580 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.580 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cor; 2024-11-21 04:53:04.587 GMT client backend[5156] pg_regress/test_extensions ERROR: collation ext_cine_coll is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.587 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.587 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.587 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.592 GMT client backend[5156] pg_regress/test_extensions ERROR: materialized view ext_cine_mv is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.592 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.592 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.592 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.600 GMT client backend[5156] pg_regress/test_extensions ERROR: server ext_cine_srv is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.600 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.600 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.600 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.606 GMT client backend[5156] pg_regress/test_extensions ERROR: schema ext_cine_schema is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.606 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.606 GMT client backend[5156] pg_regress/test_extensions CONTEXT: SQL statement "CREATE SCHEMA IF NOT EXISTS ext_cine_schema" extension script file "test_ext_cine--1.0.sql", near line 19 2024-11-21 04:53:04.606 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.613 GMT client backend[5156] pg_regress/test_extensions ERROR: sequence ext_cine_seq is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.613 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.613 GMT client backend[5156] pg_regress/test_extensions CONTEXT: SQL statement "CREATE SEQUENCE IF NOT EXISTS ext_cine_seq" extension script file "test_ext_cine--1.0.sql", near line 21 2024-11-21 04:53:04.613 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.634 GMT client backend[5156] pg_regress/test_extensions ERROR: table ext_cine_tab1 is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.634 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.634 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.634 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.672 GMT client backend[5156] pg_regress/test_extensions ERROR: table ext_cine_tab2 is not a member of extension "test_ext_cine" 2024-11-21 04:53:04.672 GMT client backend[5156] pg_regress/test_extensions DETAIL: An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns. 2024-11-21 04:53:04.672 GMT client backend[5156] pg_regress/test_extensions 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 2024-11-21 04:53:04.672 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_cine; 2024-11-21 04:53:04.698 GMT client backend[5156] pg_regress/test_extensions ERROR: invalid character in extension "test_ext_extschema" schema: must not contain any of ""$'\" 2024-11-21 04:53:04.698 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_extschema SCHEMA has$dollar; 2024-11-21 04:53:04.721 GMT client backend[5156] pg_regress/test_extensions ERROR: extension "test_ext_req_schema1" does not support SET SCHEMA 2024-11-21 04:53:04.721 GMT client backend[5156] pg_regress/test_extensions DETAIL: function test_func_dep2.dep_req1() is not in the extension's schema "test_func_dep1" 2024-11-21 04:53:04.721 GMT client backend[5156] pg_regress/test_extensions STATEMENT: ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_func_dep3; 2024-11-21 04:53:04.727 GMT client backend[5156] pg_regress/test_extensions ERROR: invalid character in extension "test_ext_req_schema1" schema: must not contain any of ""$'\" 2024-11-21 04:53:04.727 GMT client backend[5156] pg_regress/test_extensions STATEMENT: CREATE EXTENSION test_ext_req_schema3 CASCADE; 2024-11-21 04:53:04.734 GMT client backend[5156] pg_regress/test_extensions ERROR: cannot SET SCHEMA of extension "test_ext_req_schema1" because other extensions prevent it 2024-11-21 04:53:04.734 GMT client backend[5156] pg_regress/test_extensions DETAIL: Extension "test_ext_req_schema3" requests no relocation of extension "test_ext_req_schema1". 2024-11-21 04:53:04.734 GMT client backend[5156] pg_regress/test_extensions STATEMENT: ALTER EXTENSION test_ext_req_schema1 SET SCHEMA test_s_dep2; 2024-11-21 04:53:04.736 GMT client backend[5156] pg_regress/test_extensions ERROR: function public.dep_req2() does not exist at character 9 2024-11-21 04:53:04.736 GMT client backend[5156] pg_regress/test_extensions HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2024-11-21 04:53:04.736 GMT client backend[5156] pg_regress/test_extensions QUERY: SELECT public.dep_req2() || ' req3b' 2024-11-21 04:53:04.736 GMT client backend[5156] pg_regress/test_extensions CONTEXT: SQL function "dep_req3b" during startup 2024-11-21 04:53:04.736 GMT client backend[5156] pg_regress/test_extensions STATEMENT: SELECT dep_req3b(); 2024-11-21 04:53:05.044 GMT client backend[2788] pg_regress/test_extdepend ERROR: cannot drop table test_ext.a because other objects depend on it 2024-11-21 04:53:05.044 GMT client backend[2788] pg_regress/test_extdepend DETAIL: materialized view test_ext.d depends on table test_ext.a 2024-11-21 04:53:05.044 GMT client backend[2788] pg_regress/test_extdepend HINT: Use DROP ... CASCADE to drop the dependent objects too. 2024-11-21 04:53:05.044 GMT client backend[2788] pg_regress/test_extdepend STATEMENT: DROP TABLE test_ext.a; 2024-11-21 04:53:05.314 GMT postmaster[632] LOG: received fast shutdown request 2024-11-21 04:53:05.315 GMT postmaster[632] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 632 abort() has been called