2025-01-18 18:58:15.339 UTC postmaster[21535] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2025-01-18 18:58:15.339 UTC postmaster[21535] LOG:  listening on Unix socket "/tmp/pg_regress-4UFe1r/.s.PGSQL.40086"
2025-01-18 18:58:15.340 UTC startup[21538] LOG:  database system was shut down at 2025-01-18 18:58:15 UTC
2025-01-18 18:58:15.342 UTC postmaster[21535] LOG:  database system is ready to accept connections
2025-01-18 18:58:15.447 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.447 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.447 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.447 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames WARNING:  roles created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  CURRENT_USER cannot be used as a role name here at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE current_user;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  CURRENT_ROLE cannot be used as a role name here at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE current_role;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  SESSION_USER cannot be used as a role name here at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE session_user;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  syntax error at or near "user" at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE user;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  syntax error at or near "all" at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE all;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "public" is reserved at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE public;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "public" is reserved at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE "public";
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "none" is reserved at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE none;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "none" is reserved at character 13
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE "none";
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "pg_abc" is reserved
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames DETAIL:  Role names starting with "pg_" are reserved.
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE pg_abc;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "pg_abc" is reserved
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames DETAIL:  Role names starting with "pg_" are reserved.
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE "pg_abc";
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "pg_abcdef" is reserved
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames DETAIL:  Role names starting with "pg_" are reserved.
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE pg_abcdef;
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames ERROR:  role name "pg_abcdef" is reserved
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames DETAIL:  Role names starting with "pg_" are reserved.
2025-01-18 18:58:15.448 UTC client backend[21554] pg_regress/rolenames STATEMENT:  CREATE ROLE "pg_abcdef";
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 12
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE USER WITH LOGIN;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "WITH" at character 16
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE ALL WITH REPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role "session_role" does not exist
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE SESSION_ROLE WITH NOREPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE PUBLIC WITH NOREPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE "public" WITH NOREPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 12
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE NONE WITH NOREPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 12
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE "none" WITH NOREPLICATION;
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.466 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE nonexistent WITH NOREPLICATION;
2025-01-18 18:58:15.477 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 12
2025-01-18 18:58:15.477 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER USER WITH LOGIN;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "WITH" at character 16
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER ALL WITH REPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role "session_role" does not exist
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER SESSION_ROLE WITH NOREPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER PUBLIC WITH NOREPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER "public" WITH NOREPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 12
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER NONE WITH NOREPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 12
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER "none" WITH NOREPLICATION;
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.478 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER nonexistent WITH NOREPLICATION;
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 12
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE USER SET application_name to 'BOOM';
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE PUBLIC SET application_name to 'BOMB';
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.487 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER ROLE nonexistent SET application_name to 'BOMB';
2025-01-18 18:58:15.495 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 12
2025-01-18 18:58:15.495 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER USER SET application_name to 'BOOM';
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER PUBLIC SET application_name to 'BOMB';
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 12
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER NONE SET application_name to 'BOMB';
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.496 UTC client backend[21555] pg_regress/rolenames STATEMENT:  ALTER USER nonexistent SET application_name to 'BOMB';
2025-01-18 18:58:15.497 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 40
2025-01-18 18:58:15.497 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA newschemax AUTHORIZATION USER;
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA newschemax AUTHORIZATION PUBLIC;
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA newschemax AUTHORIZATION "public";
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 40
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA newschemax AUTHORIZATION NONE;
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.498 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA newschemax AUTHORIZATION nonexistent;
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 54
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION USER;
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION PUBLIC;
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION "public";
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames ERROR:  role name "none" is reserved at character 54
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION NONE;
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.500 UTC client backend[21555] pg_regress/rolenames STATEMENT:  CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION nonexistent;
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 31
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames STATEMENT:  ALTER TABLE testtab7 OWNER TO USER;
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames STATEMENT:  ALTER TABLE testtab7 OWNER TO PUBLIC;
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames STATEMENT:  ALTER TABLE testtab7 OWNER TO "public";
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.514 UTC client backend[21557] pg_regress/rolenames STATEMENT:  ALTER TABLE testtab7 OWNER TO nonexistent;
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 41
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames STATEMENT:  ALTER AGGREGATE testagg6(int2) OWNER TO USER;
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames STATEMENT:  ALTER AGGREGATE testagg6(int2) OWNER TO PUBLIC;
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames ERROR:  role "public" does not exist
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames STATEMENT:  ALTER AGGREGATE testagg6(int2) OWNER TO "public";
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.529 UTC client backend[21559] pg_regress/rolenames STATEMENT:  ALTER AGGREGATE testagg6(int2) OWNER TO nonexistent;
2025-01-18 18:58:15.541 UTC client backend[21559] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.541 UTC client backend[21559] pg_regress/rolenames STATEMENT:  CREATE USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (user 'nonexistent');
2025-01-18 18:58:15.544 UTC client backend[21559] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.544 UTC client backend[21559] pg_regress/rolenames STATEMENT:  ALTER USER MAPPING FOR nonexistent SERVER sv10
	 OPTIONS (SET user 'nonexistent_alt');
2025-01-18 18:58:15.548 UTC client backend[21559] pg_regress/rolenames ERROR:  role "nonexistent" does not exist
2025-01-18 18:58:15.548 UTC client backend[21559] pg_regress/rolenames STATEMENT:  DROP USER MAPPING FOR nonexistent SERVER sv10;
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 52
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames STATEMENT:  GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO USER;
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames ERROR:  role name "none" is reserved at character 52
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames STATEMENT:  GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO NONE;
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames ERROR:  role name "none" is reserved at character 52
2025-01-18 18:58:15.575 UTC client backend[21559] pg_regress/rolenames STATEMENT:  GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO "none";
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames ERROR:  syntax error at or near "USER" at character 55
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames STATEMENT:  REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM USER;
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames ERROR:  role name "none" is reserved at character 55
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames STATEMENT:  REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM NONE;
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames ERROR:  role name "none" is reserved at character 55
2025-01-18 18:58:15.578 UTC client backend[21559] pg_regress/rolenames STATEMENT:  REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM "none";
2025-01-18 18:58:15.583 UTC client backend[21559] pg_regress/rolenames ERROR:  permission denied to examine "session_preload_libraries"
2025-01-18 18:58:15.583 UTC client backend[21559] pg_regress/rolenames DETAIL:  Only roles with privileges of the "pg_read_all_settings" role may examine this parameter.
2025-01-18 18:58:15.583 UTC client backend[21559] pg_regress/rolenames STATEMENT:  SHOW session_preload_libraries;
2025-01-18 18:58:15.583 UTC client backend[21559] pg_regress/rolenames ERROR:  current transaction is aborted, commands ignored until end of transaction block
2025-01-18 18:58:15.583 UTC client backend[21559] pg_regress/rolenames STATEMENT:  RESET SESSION AUTHORIZATION;
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied to create "pg_catalog.test"
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table DETAIL:  System catalog modifications are currently disallowed.
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TABLE pg_catalog.test (a int);
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table ERROR:  column "b" has pseudo-type anyarray
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TABLE t1x (a int, b anyarray);
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_namespace" is a system catalog
2025-01-18 18:58:15.627 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_namespace ADD CONSTRAINT foo UNIQUE USING INDEX pg_namespace_nspname_index;
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied for table pg_description
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 1, 'foo');
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE POLICY foo ON pg_description FOR SELECT USING (description NOT LIKE 'secret%');
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table ERROR:  unacceptable schema name "pg_foo"
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table DETAIL:  The prefix "pg_" is reserved for system schemas.
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE SCHEMA pg_foo;
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.628 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  DROP TABLE pg_description;
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  TRUNCATE pg_description;
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_description RENAME COLUMN description TO comment;
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_description ALTER COLUMN description SET NOT NULL;
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.629 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_description ALTER COLUMN description SET STATISTICS -1;
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TABLE foo (a oid, b oid, c int, FOREIGN KEY (a, b, c) REFERENCES pg_description);
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE INDEX pg_description_test_index ON pg_description (description);
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_description RENAME TO pg_comment;
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TABLE pg_description SET SCHEMA public;
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table ERROR:  unacceptable tablespace name "pg_foo"
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table DETAIL:  The prefix "pg_" is reserved for system tablespaces.
2025-01-18 18:58:15.630 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TABLESPACE pg_foo LOCATION '/no/such/location';
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1();
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER TRIGGER t1 ON pg_description RENAME TO t2;
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE RULE r1 AS ON INSERT TO pg_description DO INSTEAD NOTHING;
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.631 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  ALTER RULE r1 ON pg_description RENAME TO r2;
2025-01-18 18:58:15.632 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied: "pg_description" is a system catalog
2025-01-18 18:58:15.632 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  DROP RULE r2 ON pg_description;
2025-01-18 18:58:15.637 UTC client backend[21573] pg_regress/alter_system_table ERROR:  permission denied for table pg_description
2025-01-18 18:58:15.637 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 3, 'foo');
2025-01-18 18:58:15.639 UTC client backend[21573] pg_regress/alter_system_table ERROR:  cannot drop table pg_description because it is required by the database system
2025-01-18 18:58:15.639 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  DROP TABLE pg_description;
2025-01-18 18:58:15.650 UTC client backend[21573] pg_regress/alter_system_table WARNING:  tablespaces created by regression test cases should have names starting with "regress_"
2025-01-18 18:58:15.651 UTC client backend[21573] pg_regress/alter_system_table ERROR:  directory "/no/such/location" does not exist
2025-01-18 18:58:15.651 UTC client backend[21573] pg_regress/alter_system_table STATEMENT:  CREATE TABLESPACE pg_foo LOCATION '/no/such/location';
2025-01-18 18:58:15.660 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "ignore_system_indexes" cannot be set after connection start
2025-01-18 18:58:15.660 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SET ignore_system_indexes = OFF;
2025-01-18 18:58:15.660 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "ignore_system_indexes" cannot be set after connection start
2025-01-18 18:58:15.660 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  RESET ignore_system_indexes;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "block_size" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SET block_size = 50;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "block_size" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  RESET block_size;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "block_size" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET block_size = 50;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "block_size" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET block_size;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SET autovacuum_freeze_max_age = 1000050000;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  RESET autovacuum_freeze_max_age;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "config_file" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET config_file = '/usr/local/data/postgresql.conf';
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "config_file" cannot be changed
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET config_file;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "autovacuum" cannot be changed now
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SET autovacuum = OFF;
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "autovacuum" cannot be changed now
2025-01-18 18:58:15.661 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  RESET autovacuum;
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "jit_debugging_support" cannot be set after connection start
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SET jit_debugging_support = OFF;
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "jit_debugging_support" cannot be set after connection start
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  RESET jit_debugging_support;
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "ssl_renegotiation_limit" cannot be changed
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET ssl_renegotiation_limit = 0;
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs ERROR:  parameter "ssl_renegotiation_limit" cannot be changed
2025-01-18 18:58:15.662 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET ssl_renegotiation_limit;
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs ERROR:  unrecognized privilege type: "SELECT"
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE');
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs ERROR:  unrecognized privilege type: "USAGE"
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE');
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs ERROR:  unrecognized privilege type: "WHATEVER"
2025-01-18 18:58:15.664 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER');
2025-01-18 18:58:15.670 UTC client backend[21576] pg_regress/guc_privs ERROR:  unrecognized configuration parameter "none.such"
2025-01-18 18:58:15.670 UTC client backend[21576] pg_regress/guc_privs STATEMENT:  SHOW none.such;
2025-01-18 18:58:15.670 UTC postmaster[21535] LOG:  received SIGHUP, reloading configuration files
2025-01-18 18:58:15.670 UTC postmaster[21535] LOG:  parameter "none.such" changed to "whiz bang"
2025-01-18 18:58:15.673 UTC client backend[21577] pg_regress/guc_privs ERROR:  unrecognized configuration parameter "no_such_guc"
2025-01-18 18:58:15.673 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  GRANT ALL ON PARAMETER no_such_guc TO regress_host_resource_admin;
2025-01-18 18:58:15.680 UTC client backend[21577] pg_regress/guc_privs ERROR:  unrecognized privilege type: "SELECT"
2025-01-18 18:58:15.680 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE');
2025-01-18 18:58:15.680 UTC client backend[21577] pg_regress/guc_privs ERROR:  unrecognized privilege type: "USAGE"
2025-01-18 18:58:15.680 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE');
2025-01-18 18:58:15.681 UTC client backend[21577] pg_regress/guc_privs ERROR:  unrecognized privilege type: "WHATEVER"
2025-01-18 18:58:15.681 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER');
2025-01-18 18:58:15.681 UTC client backend[21577] pg_regress/guc_privs ERROR:  unrecognized privilege type: "WHATEVER WITH GRANT OPTION"
2025-01-18 18:58:15.681 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER WITH GRANT OPTION');
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "ignore_system_indexes"
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET ignore_system_indexes = OFF;
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "autovacuum_multixact_freeze_max_age"
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET autovacuum_multixact_freeze_max_age;
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs ERROR:  parameter "jit_provider" cannot be changed without restarting the server
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SET jit_provider = 'llvmjit';
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs ERROR:  parameter "jit_provider" cannot be changed without restarting the server
2025-01-18 18:58:15.684 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SELECT set_config ('jit_provider', 'llvmjit', true);
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs ERROR:  parameter "autovacuum_work_mem" cannot be changed now
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SET autovacuum_work_mem = 50;
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "lc_messages"
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  SET lc_messages = 'C';
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "lc_messages"
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  RESET lc_messages;
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "lc_messages"
2025-01-18 18:58:15.685 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET lc_messages = 'C';
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "lc_messages"
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET lc_messages;
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to perform ALTER SYSTEM RESET ALL
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM RESET ALL;
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "none.such2"
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET none.such2 = 'whiz bang';
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "lc_messages"
2025-01-18 18:58:15.686 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER ROLE regress_host_resource_admin SET lc_messages = 'POSIX';
2025-01-18 18:58:15.690 UTC client backend[21577] pg_regress/guc_privs ERROR:  role "regress_host_resource_admin" cannot be dropped because some objects depend on it
2025-01-18 18:58:15.690 UTC client backend[21577] pg_regress/guc_privs DETAIL:  privileges for parameter autovacuum_work_mem
	privileges for parameter hash_mem_multiplier
	privileges for parameter max_stack_depth
	privileges for parameter shared_buffers
	privileges for parameter temp_file_limit
	privileges for parameter work_mem
2025-01-18 18:58:15.690 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  DROP ROLE regress_host_resource_admin;
2025-01-18 18:58:15.690 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "autovacuum_work_mem"
2025-01-18 18:58:15.690 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET autovacuum_work_mem = 32;
2025-01-18 18:58:15.692 UTC client backend[21577] pg_regress/guc_privs ERROR:  role "regress_host_resource_admin" cannot be dropped because some objects depend on it
2025-01-18 18:58:15.692 UTC client backend[21577] pg_regress/guc_privs DETAIL:  privileges for parameter autovacuum_work_mem
	privileges for parameter hash_mem_multiplier
	privileges for parameter max_stack_depth
	privileges for parameter shared_buffers
	privileges for parameter temp_file_limit
	privileges for parameter work_mem
2025-01-18 18:58:15.692 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  DROP ROLE regress_host_resource_admin;
2025-01-18 18:58:15.692 UTC client backend[21577] pg_regress/guc_privs ERROR:  permission denied to set parameter "autovacuum_work_mem"
2025-01-18 18:58:15.692 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  ALTER SYSTEM SET autovacuum_work_mem = 32;
2025-01-18 18:58:15.695 UTC client backend[21577] pg_regress/guc_privs ERROR:  role "regress_host_resource_admin" cannot be dropped because some objects depend on it
2025-01-18 18:58:15.695 UTC client backend[21577] pg_regress/guc_privs DETAIL:  privileges for parameter autovacuum_work_mem
	privileges for parameter hash_mem_multiplier
	privileges for parameter max_stack_depth
	privileges for parameter shared_buffers
	privileges for parameter temp_file_limit
	privileges for parameter work_mem
2025-01-18 18:58:15.695 UTC client backend[21577] pg_regress/guc_privs STATEMENT:  DROP ROLE regress_host_resource_admin;
2025-01-18 18:58:15.699 UTC postmaster[21535] LOG:  received fast shutdown request
2025-01-18 18:58:15.699 UTC postmaster[21535] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2909, PID: 21535
0xaa3af2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89d2d5 <PostmasterStateMachine+0x875> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89af45 <ServerLoop+0x555> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89a164 <PostmasterMain+0x11c4> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres