2024-12-27 05:37:09.481 UTC postmaster[21441] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-12-27 05:37:09.481 UTC postmaster[21441] LOG: listening on Unix socket "/tmp/pg_regress-7oRLEz/.s.PGSQL.40086" 2024-12-27 05:37:09.483 UTC startup[21444] LOG: database system was shut down at 2024-12-27 05:37:09 UTC 2024-12-27 05:37:09.484 UTC postmaster[21441] LOG: database system is ready to accept connections 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.594 UTC client backend[21460] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: CURRENT_USER cannot be used as a role name here at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE current_user; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: CURRENT_ROLE cannot be used as a role name here at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE current_role; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: SESSION_USER cannot be used as a role name here at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE session_user; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: syntax error at or near "user" at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE user; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: syntax error at or near "all" at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE all; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE public; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE "public"; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE none; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE "none"; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abc; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abc"; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abcdef; 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2024-12-27 05:37:09.595 UTC client backend[21460] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abcdef"; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE USER WITH LOGIN; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE ALL WITH REPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role "session_role" does not exist 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE SESSION_ROLE WITH NOREPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC WITH NOREPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE "public" WITH NOREPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE NONE WITH NOREPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE "none" WITH NOREPLICATION; 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.613 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER USER WITH LOGIN; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER ALL WITH REPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role "session_role" does not exist 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER SESSION_ROLE WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER "public" WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER NONE WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER "none" WITH NOREPLICATION; 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.624 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER nonexistent WITH NOREPLICATION; 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE USER SET application_name to 'BOOM'; 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC SET application_name to 'BOMB'; 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.633 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent SET application_name to 'BOMB'; 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER USER SET application_name to 'BOOM'; 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC SET application_name to 'BOMB'; 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER NONE SET application_name to 'BOMB'; 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.642 UTC client backend[21461] pg_regress/rolenames STATEMENT: ALTER USER nonexistent SET application_name to 'BOMB'; 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 40 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION USER; 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION PUBLIC; 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION "public"; 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 40 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION NONE; 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.644 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION nonexistent; 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 54 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION USER; 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION PUBLIC; 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION "public"; 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames ERROR: role name "none" is reserved at character 54 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION NONE; 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.646 UTC client backend[21461] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION nonexistent; 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 31 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO USER; 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO PUBLIC; 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO "public"; 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.661 UTC client backend[21463] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO nonexistent; 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 41 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO USER; 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO PUBLIC; 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames ERROR: role "public" does not exist 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO "public"; 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.678 UTC client backend[21465] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO nonexistent; 2024-12-27 05:37:09.690 UTC client backend[21465] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.690 UTC client backend[21465] pg_regress/rolenames STATEMENT: CREATE USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (user 'nonexistent'); 2024-12-27 05:37:09.694 UTC client backend[21465] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.694 UTC client backend[21465] pg_regress/rolenames STATEMENT: ALTER USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (SET user 'nonexistent_alt'); 2024-12-27 05:37:09.698 UTC client backend[21465] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2024-12-27 05:37:09.698 UTC client backend[21465] pg_regress/rolenames STATEMENT: DROP USER MAPPING FOR nonexistent SERVER sv10; 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 52 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO USER; 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO NONE; 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2024-12-27 05:37:09.724 UTC client backend[21465] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO "none"; 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 55 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM USER; 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM NONE; 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2024-12-27 05:37:09.727 UTC client backend[21465] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM "none"; 2024-12-27 05:37:09.732 UTC client backend[21465] pg_regress/rolenames ERROR: permission denied to examine "session_preload_libraries" 2024-12-27 05:37:09.732 UTC client backend[21465] pg_regress/rolenames DETAIL: Only roles with privileges of the "pg_read_all_settings" role may examine this parameter. 2024-12-27 05:37:09.732 UTC client backend[21465] pg_regress/rolenames STATEMENT: SHOW session_preload_libraries; 2024-12-27 05:37:09.732 UTC client backend[21465] pg_regress/rolenames ERROR: current transaction is aborted, commands ignored until end of transaction block 2024-12-27 05:37:09.732 UTC client backend[21465] pg_regress/rolenames STATEMENT: RESET SESSION AUTHORIZATION; 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied to create "pg_catalog.test" 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table DETAIL: System catalog modifications are currently disallowed. 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TABLE pg_catalog.test (a int); 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table ERROR: column "b" has pseudo-type anyarray 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TABLE t1x (a int, b anyarray); 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_namespace" is a system catalog 2024-12-27 05:37:09.783 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_namespace ADD CONSTRAINT foo UNIQUE USING INDEX pg_namespace_nspname_index; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 1, 'foo'); 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE POLICY foo ON pg_description FOR SELECT USING (description NOT LIKE 'secret%'); 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: unacceptable schema name "pg_foo" 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system schemas. 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE SCHEMA pg_foo; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: TRUNCATE pg_description; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME COLUMN description TO comment; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET NOT NULL; 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.785 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET STATISTICS -1; 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TABLE foo (a oid, b oid, c int, FOREIGN KEY (a, b, c) REFERENCES pg_description); 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE INDEX pg_description_test_index ON pg_description (description); 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.786 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME TO pg_comment; 2024-12-27 05:37:09.787 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.787 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description SET SCHEMA public; 2024-12-27 05:37:09.787 UTC client backend[21479] pg_regress/alter_system_table ERROR: unacceptable tablespace name "pg_foo" 2024-12-27 05:37:09.787 UTC client backend[21479] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system tablespaces. 2024-12-27 05:37:09.787 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER TRIGGER t1 ON pg_description RENAME TO t2; 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE RULE r1 AS ON INSERT TO pg_description DO INSTEAD NOTHING; 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.788 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: ALTER RULE r1 ON pg_description RENAME TO r2; 2024-12-27 05:37:09.789 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2024-12-27 05:37:09.789 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: DROP RULE r2 ON pg_description; 2024-12-27 05:37:09.794 UTC client backend[21479] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2024-12-27 05:37:09.794 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 3, 'foo'); 2024-12-27 05:37:09.796 UTC client backend[21479] pg_regress/alter_system_table ERROR: cannot drop table pg_description because it is required by the database system 2024-12-27 05:37:09.796 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2024-12-27 05:37:09.807 UTC client backend[21479] pg_regress/alter_system_table WARNING: tablespaces created by regression test cases should have names starting with "regress_" 2024-12-27 05:37:09.808 UTC client backend[21479] pg_regress/alter_system_table ERROR: directory "/no/such/location" does not exist 2024-12-27 05:37:09.808 UTC client backend[21479] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2024-12-27 05:37:09.819 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2024-12-27 05:37:09.819 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SET ignore_system_indexes = OFF; 2024-12-27 05:37:09.819 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2024-12-27 05:37:09.819 UTC client backend[21482] pg_regress/guc_privs STATEMENT: RESET ignore_system_indexes; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SET block_size = 50; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: RESET block_size; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET block_size = 50; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET block_size; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SET autovacuum_freeze_max_age = 1000050000; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: RESET autovacuum_freeze_max_age; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET config_file = '/usr/local/data/postgresql.conf'; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET config_file; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SET autovacuum = OFF; 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2024-12-27 05:37:09.820 UTC client backend[21482] pg_regress/guc_privs STATEMENT: RESET autovacuum; 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SET jit_debugging_support = OFF; 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs STATEMENT: RESET jit_debugging_support; 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ssl_renegotiation_limit = 0; 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2024-12-27 05:37:09.821 UTC client backend[21482] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ssl_renegotiation_limit; 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2024-12-27 05:37:09.823 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2024-12-27 05:37:09.829 UTC client backend[21482] pg_regress/guc_privs ERROR: unrecognized configuration parameter "none.such" 2024-12-27 05:37:09.829 UTC client backend[21482] pg_regress/guc_privs STATEMENT: SHOW none.such; 2024-12-27 05:37:09.829 UTC postmaster[21441] LOG: received SIGHUP, reloading configuration files 2024-12-27 05:37:09.830 UTC postmaster[21441] LOG: parameter "none.such" changed to "whiz bang" 2024-12-27 05:37:09.833 UTC client backend[21483] pg_regress/guc_privs ERROR: unrecognized configuration parameter "no_such_guc" 2024-12-27 05:37:09.833 UTC client backend[21483] pg_regress/guc_privs STATEMENT: GRANT ALL ON PARAMETER no_such_guc TO regress_host_resource_admin; 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER WITH GRANT OPTION" 2024-12-27 05:37:09.840 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER WITH GRANT OPTION'); 2024-12-27 05:37:09.843 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "ignore_system_indexes" 2024-12-27 05:37:09.843 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ignore_system_indexes = OFF; 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_multixact_freeze_max_age" 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET autovacuum_multixact_freeze_max_age; 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SET jit_provider = 'llvmjit'; 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SELECT set_config ('jit_provider', 'llvmjit', true); 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs ERROR: parameter "autovacuum_work_mem" cannot be changed now 2024-12-27 05:37:09.844 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SET autovacuum_work_mem = 50; 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs STATEMENT: SET lc_messages = 'C'; 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs STATEMENT: RESET lc_messages; 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET lc_messages = 'C'; 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET lc_messages; 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to perform ALTER SYSTEM RESET ALL 2024-12-27 05:37:09.845 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ALL; 2024-12-27 05:37:09.846 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "none.such2" 2024-12-27 05:37:09.846 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET none.such2 = 'whiz bang'; 2024-12-27 05:37:09.846 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2024-12-27 05:37:09.846 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER ROLE regress_host_resource_admin SET lc_messages = 'POSIX'; 2024-12-27 05:37:09.849 UTC client backend[21483] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2024-12-27 05:37:09.849 UTC client backend[21483] 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 2024-12-27 05:37:09.849 UTC client backend[21483] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2024-12-27 05:37:09.850 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2024-12-27 05:37:09.850 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2024-12-27 05:37:09.851 UTC client backend[21483] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2024-12-27 05:37:09.851 UTC client backend[21483] 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 2024-12-27 05:37:09.851 UTC client backend[21483] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2024-12-27 05:37:09.852 UTC client backend[21483] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2024-12-27 05:37:09.852 UTC client backend[21483] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2024-12-27 05:37:09.854 UTC client backend[21483] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2024-12-27 05:37:09.854 UTC client backend[21483] 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 2024-12-27 05:37:09.854 UTC client backend[21483] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2024-12-27 05:37:09.858 UTC postmaster[21441] LOG: received fast shutdown request 2024-12-27 05:37:09.858 UTC postmaster[21441] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 21441 0xaa80a2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a22c7 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a07c9 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89fba4 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres