2025-01-15 10:30:44.822 UTC postmaster[21509] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2025-01-15 10:30:44.822 UTC postmaster[21509] LOG: listening on Unix socket "/tmp/pg_regress-lUtCCz/.s.PGSQL.40086" 2025-01-15 10:30:44.824 UTC startup[21512] LOG: database system was shut down at 2025-01-15 10:30:44 UTC 2025-01-15 10:30:44.825 UTC postmaster[21509] LOG: database system is ready to accept connections 2025-01-15 10:30:44.934 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.934 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.934 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: CURRENT_USER cannot be used as a role name here at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE current_user; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: CURRENT_ROLE cannot be used as a role name here at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE current_role; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: SESSION_USER cannot be used as a role name here at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE session_user; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: syntax error at or near "user" at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE user; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: syntax error at or near "all" at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE all; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE public; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE "public"; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE none; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE "none"; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abc; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abc"; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abcdef; 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-15 10:30:44.935 UTC client backend[21528] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abcdef"; 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE USER WITH LOGIN; 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE ALL WITH REPLICATION; 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE SESSION_ROLE WITH NOREPLICATION; 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.954 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC WITH NOREPLICATION; 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE "public" WITH NOREPLICATION; 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE NONE WITH NOREPLICATION; 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE "none" WITH NOREPLICATION; 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.955 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER USER WITH LOGIN; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER ALL WITH REPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER SESSION_ROLE WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER "public" WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER NONE WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER "none" WITH NOREPLICATION; 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.966 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER nonexistent WITH NOREPLICATION; 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE USER SET application_name to 'BOOM'; 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC SET application_name to 'BOMB'; 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.976 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent SET application_name to 'BOMB'; 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER USER SET application_name to 'BOOM'; 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC SET application_name to 'BOMB'; 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER NONE SET application_name to 'BOMB'; 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.984 UTC client backend[21529] pg_regress/rolenames STATEMENT: ALTER USER nonexistent SET application_name to 'BOMB'; 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 40 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION USER; 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION PUBLIC; 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.986 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION "public"; 2025-01-15 10:30:44.987 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 40 2025-01-15 10:30:44.987 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION NONE; 2025-01-15 10:30:44.987 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.987 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION nonexistent; 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 54 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION USER; 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION PUBLIC; 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION "public"; 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames ERROR: role name "none" is reserved at character 54 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION NONE; 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:44.989 UTC client backend[21529] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION nonexistent; 2025-01-15 10:30:45.004 UTC client backend[21531] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 31 2025-01-15 10:30:45.004 UTC client backend[21531] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO USER; 2025-01-15 10:30:45.004 UTC client backend[21531] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:45.004 UTC client backend[21531] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO PUBLIC; 2025-01-15 10:30:45.005 UTC client backend[21531] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:45.005 UTC client backend[21531] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO "public"; 2025-01-15 10:30:45.005 UTC client backend[21531] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:45.005 UTC client backend[21531] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO nonexistent; 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 41 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO USER; 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO PUBLIC; 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO "public"; 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:45.022 UTC client backend[21533] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO nonexistent; 2025-01-15 10:30:45.034 UTC client backend[21533] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:45.034 UTC client backend[21533] pg_regress/rolenames STATEMENT: CREATE USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (user 'nonexistent'); 2025-01-15 10:30:45.037 UTC client backend[21533] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:45.037 UTC client backend[21533] pg_regress/rolenames STATEMENT: ALTER USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (SET user 'nonexistent_alt'); 2025-01-15 10:30:45.041 UTC client backend[21533] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-15 10:30:45.041 UTC client backend[21533] pg_regress/rolenames STATEMENT: DROP USER MAPPING FOR nonexistent SERVER sv10; 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 52 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO USER; 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO NONE; 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-15 10:30:45.069 UTC client backend[21533] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO "none"; 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 55 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM USER; 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM NONE; 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-15 10:30:45.071 UTC client backend[21533] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM "none"; 2025-01-15 10:30:45.077 UTC client backend[21533] pg_regress/rolenames ERROR: permission denied to examine "session_preload_libraries" 2025-01-15 10:30:45.077 UTC client backend[21533] pg_regress/rolenames DETAIL: Only roles with privileges of the "pg_read_all_settings" role may examine this parameter. 2025-01-15 10:30:45.077 UTC client backend[21533] pg_regress/rolenames STATEMENT: SHOW session_preload_libraries; 2025-01-15 10:30:45.077 UTC client backend[21533] pg_regress/rolenames ERROR: current transaction is aborted, commands ignored until end of transaction block 2025-01-15 10:30:45.077 UTC client backend[21533] pg_regress/rolenames STATEMENT: RESET SESSION AUTHORIZATION; 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied to create "pg_catalog.test" 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table DETAIL: System catalog modifications are currently disallowed. 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE TABLE pg_catalog.test (a int); 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table ERROR: column "b" has pseudo-type anyarray 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE TABLE t1x (a int, b anyarray); 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_namespace" is a system catalog 2025-01-15 10:30:45.128 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_namespace ADD CONSTRAINT foo UNIQUE USING INDEX pg_namespace_nspname_index; 2025-01-15 10:30:45.129 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-15 10:30:45.129 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 1, 'foo'); 2025-01-15 10:30:45.129 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.129 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE POLICY foo ON pg_description FOR SELECT USING (description NOT LIKE 'secret%'); 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: unacceptable schema name "pg_foo" 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system schemas. 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE SCHEMA pg_foo; 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: TRUNCATE pg_description; 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME COLUMN description TO comment; 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET NOT NULL; 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.130 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET STATISTICS -1; 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.131 UTC client backend[21547] 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-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE INDEX pg_description_test_index ON pg_description (description); 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME TO pg_comment; 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description SET SCHEMA public; 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table ERROR: unacceptable tablespace name "pg_foo" 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system tablespaces. 2025-01-15 10:30:45.131 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER TRIGGER t1 ON pg_description RENAME TO t2; 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE RULE r1 AS ON INSERT TO pg_description DO INSTEAD NOTHING; 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.133 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: ALTER RULE r1 ON pg_description RENAME TO r2; 2025-01-15 10:30:45.134 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-15 10:30:45.134 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: DROP RULE r2 ON pg_description; 2025-01-15 10:30:45.139 UTC client backend[21547] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-15 10:30:45.139 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 3, 'foo'); 2025-01-15 10:30:45.141 UTC client backend[21547] pg_regress/alter_system_table ERROR: cannot drop table pg_description because it is required by the database system 2025-01-15 10:30:45.141 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-15 10:30:45.153 UTC client backend[21547] pg_regress/alter_system_table WARNING: tablespaces created by regression test cases should have names starting with "regress_" 2025-01-15 10:30:45.154 UTC client backend[21547] pg_regress/alter_system_table ERROR: directory "/no/such/location" does not exist 2025-01-15 10:30:45.154 UTC client backend[21547] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-15 10:30:45.164 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-15 10:30:45.164 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SET ignore_system_indexes = OFF; 2025-01-15 10:30:45.164 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-15 10:30:45.164 UTC client backend[21550] pg_regress/guc_privs STATEMENT: RESET ignore_system_indexes; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SET block_size = 50; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: RESET block_size; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET block_size = 50; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET block_size; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SET autovacuum_freeze_max_age = 1000050000; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: RESET autovacuum_freeze_max_age; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET config_file = '/usr/local/data/postgresql.conf'; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET config_file; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SET autovacuum = OFF; 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-15 10:30:45.165 UTC client backend[21550] pg_regress/guc_privs STATEMENT: RESET autovacuum; 2025-01-15 10:30:45.166 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-15 10:30:45.166 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SET jit_debugging_support = OFF; 2025-01-15 10:30:45.166 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-15 10:30:45.166 UTC client backend[21550] pg_regress/guc_privs STATEMENT: RESET jit_debugging_support; 2025-01-15 10:30:45.167 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-15 10:30:45.167 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ssl_renegotiation_limit = 0; 2025-01-15 10:30:45.167 UTC client backend[21550] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-15 10:30:45.167 UTC client backend[21550] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ssl_renegotiation_limit; 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-15 10:30:45.168 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-15 10:30:45.174 UTC client backend[21550] pg_regress/guc_privs ERROR: unrecognized configuration parameter "none.such" 2025-01-15 10:30:45.174 UTC client backend[21550] pg_regress/guc_privs STATEMENT: SHOW none.such; 2025-01-15 10:30:45.174 UTC postmaster[21509] LOG: received SIGHUP, reloading configuration files 2025-01-15 10:30:45.175 UTC postmaster[21509] LOG: parameter "none.such" changed to "whiz bang" 2025-01-15 10:30:45.178 UTC client backend[21551] pg_regress/guc_privs ERROR: unrecognized configuration parameter "no_such_guc" 2025-01-15 10:30:45.178 UTC client backend[21551] pg_regress/guc_privs STATEMENT: GRANT ALL ON PARAMETER no_such_guc TO regress_host_resource_admin; 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER WITH GRANT OPTION" 2025-01-15 10:30:45.186 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER WITH GRANT OPTION'); 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "ignore_system_indexes" 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ignore_system_indexes = OFF; 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_multixact_freeze_max_age" 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET autovacuum_multixact_freeze_max_age; 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-15 10:30:45.189 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SET jit_provider = 'llvmjit'; 2025-01-15 10:30:45.190 UTC client backend[21551] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-15 10:30:45.190 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SELECT set_config ('jit_provider', 'llvmjit', true); 2025-01-15 10:30:45.190 UTC client backend[21551] pg_regress/guc_privs ERROR: parameter "autovacuum_work_mem" cannot be changed now 2025-01-15 10:30:45.190 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SET autovacuum_work_mem = 50; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: SET lc_messages = 'C'; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: RESET lc_messages; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET lc_messages = 'C'; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET lc_messages; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to perform ALTER SYSTEM RESET ALL 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ALL; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "none.such2" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET none.such2 = 'whiz bang'; 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-15 10:30:45.191 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER ROLE regress_host_resource_admin SET lc_messages = 'POSIX'; 2025-01-15 10:30:45.195 UTC client backend[21551] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-15 10:30:45.195 UTC client backend[21551] 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-15 10:30:45.195 UTC client backend[21551] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-15 10:30:45.196 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-15 10:30:45.196 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-15 10:30:45.197 UTC client backend[21551] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-15 10:30:45.197 UTC client backend[21551] 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-15 10:30:45.197 UTC client backend[21551] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-15 10:30:45.198 UTC client backend[21551] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-15 10:30:45.198 UTC client backend[21551] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-15 10:30:45.200 UTC client backend[21551] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-15 10:30:45.200 UTC client backend[21551] 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-15 10:30:45.200 UTC client backend[21551] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-15 10:30:45.204 UTC postmaster[21509] LOG: received fast shutdown request 2025-01-15 10:30:45.204 UTC postmaster[21509] 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: 21509 0xaab902 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a5945 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a35b5 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a27d4 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres