2025-01-31 22:42:42.877 UTC postmaster[21628] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2025-01-31 22:42:42.877 UTC postmaster[21628] LOG: listening on Unix socket "/tmp/pg_regress-X9dVIc/.s.PGSQL.40086" 2025-01-31 22:42:42.879 UTC startup[21631] LOG: database system was shut down at 2025-01-31 22:42:42 UTC 2025-01-31 22:42:42.881 UTC postmaster[21628] LOG: database system is ready to accept connections 2025-01-31 22:42:43.004 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.004 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.004 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.004 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.004 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames WARNING: roles created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: CURRENT_USER cannot be used as a role name here at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE current_user; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: CURRENT_ROLE cannot be used as a role name here at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE current_role; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: SESSION_USER cannot be used as a role name here at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE session_user; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: syntax error at or near "user" at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE user; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: syntax error at or near "all" at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE all; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE public; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE "public"; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE none; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE "none"; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abc; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abc"; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abcdef; 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-31 22:42:43.005 UTC client backend[21647] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abcdef"; 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE USER WITH LOGIN; 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE ALL WITH REPLICATION; 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-31 22:42:43.026 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE SESSION_ROLE WITH NOREPLICATION; 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC WITH NOREPLICATION; 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE "public" WITH NOREPLICATION; 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE NONE WITH NOREPLICATION; 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE "none" WITH NOREPLICATION; 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.027 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER USER WITH LOGIN; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER ALL WITH REPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER SESSION_ROLE WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER "public" WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER NONE WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER "none" WITH NOREPLICATION; 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.039 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER nonexistent WITH NOREPLICATION; 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE USER SET application_name to 'BOOM'; 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC SET application_name to 'BOMB'; 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.049 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent SET application_name to 'BOMB'; 2025-01-31 22:42:43.058 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-31 22:42:43.058 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER USER SET application_name to 'BOOM'; 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC SET application_name to 'BOMB'; 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER NONE SET application_name to 'BOMB'; 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.059 UTC client backend[21648] pg_regress/rolenames STATEMENT: ALTER USER nonexistent SET application_name to 'BOMB'; 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 40 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION USER; 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION PUBLIC; 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION "public"; 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 40 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION NONE; 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.061 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION nonexistent; 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 54 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION USER; 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION PUBLIC; 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION "public"; 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames ERROR: role name "none" is reserved at character 54 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION NONE; 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.063 UTC client backend[21648] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION nonexistent; 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 31 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO USER; 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO PUBLIC; 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO "public"; 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.080 UTC client backend[21650] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO nonexistent; 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 41 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO USER; 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO PUBLIC; 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-31 22:42:43.098 UTC client backend[21652] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO "public"; 2025-01-31 22:42:43.099 UTC client backend[21652] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.099 UTC client backend[21652] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO nonexistent; 2025-01-31 22:42:43.111 UTC client backend[21652] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.111 UTC client backend[21652] pg_regress/rolenames STATEMENT: CREATE USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (user 'nonexistent'); 2025-01-31 22:42:43.115 UTC client backend[21652] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.115 UTC client backend[21652] pg_regress/rolenames STATEMENT: ALTER USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (SET user 'nonexistent_alt'); 2025-01-31 22:42:43.119 UTC client backend[21652] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-31 22:42:43.119 UTC client backend[21652] pg_regress/rolenames STATEMENT: DROP USER MAPPING FOR nonexistent SERVER sv10; 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 52 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO USER; 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO NONE; 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-31 22:42:43.147 UTC client backend[21652] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO "none"; 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 55 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM USER; 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM NONE; 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-31 22:42:43.150 UTC client backend[21652] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM "none"; 2025-01-31 22:42:43.156 UTC client backend[21652] pg_regress/rolenames ERROR: permission denied to examine "session_preload_libraries" 2025-01-31 22:42:43.156 UTC client backend[21652] pg_regress/rolenames DETAIL: Only roles with privileges of the "pg_read_all_settings" role may examine this parameter. 2025-01-31 22:42:43.156 UTC client backend[21652] pg_regress/rolenames STATEMENT: SHOW session_preload_libraries; 2025-01-31 22:42:43.156 UTC client backend[21652] pg_regress/rolenames ERROR: current transaction is aborted, commands ignored until end of transaction block 2025-01-31 22:42:43.156 UTC client backend[21652] pg_regress/rolenames STATEMENT: RESET SESSION AUTHORIZATION; 2025-01-31 22:42:43.220 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied to create "pg_catalog.test" 2025-01-31 22:42:43.220 UTC client backend[21666] pg_regress/alter_system_table DETAIL: System catalog modifications are currently disallowed. 2025-01-31 22:42:43.220 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE TABLE pg_catalog.test (a int); 2025-01-31 22:42:43.221 UTC client backend[21666] pg_regress/alter_system_table ERROR: column "b" has pseudo-type anyarray 2025-01-31 22:42:43.221 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE TABLE t1x (a int, b anyarray); 2025-01-31 22:42:43.221 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_namespace" is a system catalog 2025-01-31 22:42:43.221 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_namespace ADD CONSTRAINT foo UNIQUE USING INDEX pg_namespace_nspname_index; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 1, 'foo'); 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE POLICY foo ON pg_description FOR SELECT USING (description NOT LIKE 'secret%'); 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: unacceptable schema name "pg_foo" 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system schemas. 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE SCHEMA pg_foo; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: TRUNCATE pg_description; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME COLUMN description TO comment; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET NOT NULL; 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.223 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET STATISTICS -1; 2025-01-31 22:42:43.224 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.224 UTC client backend[21666] 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-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE INDEX pg_description_test_index ON pg_description (description); 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME TO pg_comment; 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description SET SCHEMA public; 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table ERROR: unacceptable tablespace name "pg_foo" 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system tablespaces. 2025-01-31 22:42:43.225 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER TRIGGER t1 ON pg_description RENAME TO t2; 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE RULE r1 AS ON INSERT TO pg_description DO INSTEAD NOTHING; 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.226 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: ALTER RULE r1 ON pg_description RENAME TO r2; 2025-01-31 22:42:43.227 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-31 22:42:43.227 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: DROP RULE r2 ON pg_description; 2025-01-31 22:42:43.233 UTC client backend[21666] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-31 22:42:43.233 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 3, 'foo'); 2025-01-31 22:42:43.235 UTC client backend[21666] pg_regress/alter_system_table ERROR: cannot drop table pg_description because it is required by the database system 2025-01-31 22:42:43.235 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-31 22:42:43.248 UTC client backend[21666] pg_regress/alter_system_table WARNING: tablespaces created by regression test cases should have names starting with "regress_" 2025-01-31 22:42:43.249 UTC client backend[21666] pg_regress/alter_system_table ERROR: directory "/no/such/location" does not exist 2025-01-31 22:42:43.249 UTC client backend[21666] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-31 22:42:43.262 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-31 22:42:43.262 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SET ignore_system_indexes = OFF; 2025-01-31 22:42:43.262 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-31 22:42:43.262 UTC client backend[21669] pg_regress/guc_privs STATEMENT: RESET ignore_system_indexes; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SET block_size = 50; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: RESET block_size; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET block_size = 50; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET block_size; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SET autovacuum_freeze_max_age = 1000050000; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: RESET autovacuum_freeze_max_age; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET config_file = '/usr/local/data/postgresql.conf'; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET config_file; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SET autovacuum = OFF; 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-31 22:42:43.263 UTC client backend[21669] pg_regress/guc_privs STATEMENT: RESET autovacuum; 2025-01-31 22:42:43.264 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-31 22:42:43.264 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SET jit_debugging_support = OFF; 2025-01-31 22:42:43.264 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-31 22:42:43.264 UTC client backend[21669] pg_regress/guc_privs STATEMENT: RESET jit_debugging_support; 2025-01-31 22:42:43.265 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-31 22:42:43.265 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ssl_renegotiation_limit = 0; 2025-01-31 22:42:43.265 UTC client backend[21669] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-31 22:42:43.265 UTC client backend[21669] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ssl_renegotiation_limit; 2025-01-31 22:42:43.266 UTC client backend[21669] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-31 22:42:43.266 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-31 22:42:43.267 UTC client backend[21669] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-31 22:42:43.267 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-31 22:42:43.267 UTC client backend[21669] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-31 22:42:43.267 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-31 22:42:43.273 UTC client backend[21669] pg_regress/guc_privs ERROR: unrecognized configuration parameter "none.such" 2025-01-31 22:42:43.273 UTC client backend[21669] pg_regress/guc_privs STATEMENT: SHOW none.such; 2025-01-31 22:42:43.273 UTC postmaster[21628] LOG: received SIGHUP, reloading configuration files 2025-01-31 22:42:43.274 UTC postmaster[21628] LOG: parameter "none.such" changed to "whiz bang" 2025-01-31 22:42:43.278 UTC client backend[21670] pg_regress/guc_privs ERROR: unrecognized configuration parameter "no_such_guc" 2025-01-31 22:42:43.278 UTC client backend[21670] pg_regress/guc_privs STATEMENT: GRANT ALL ON PARAMETER no_such_guc TO regress_host_resource_admin; 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER WITH GRANT OPTION" 2025-01-31 22:42:43.287 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER WITH GRANT OPTION'); 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "ignore_system_indexes" 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ignore_system_indexes = OFF; 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_multixact_freeze_max_age" 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET autovacuum_multixact_freeze_max_age; 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SET jit_provider = 'llvmjit'; 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-31 22:42:43.291 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SELECT set_config ('jit_provider', 'llvmjit', true); 2025-01-31 22:42:43.292 UTC client backend[21670] pg_regress/guc_privs ERROR: parameter "autovacuum_work_mem" cannot be changed now 2025-01-31 22:42:43.292 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SET autovacuum_work_mem = 50; 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs STATEMENT: SET lc_messages = 'C'; 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs STATEMENT: RESET lc_messages; 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET lc_messages = 'C'; 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET lc_messages; 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to perform ALTER SYSTEM RESET ALL 2025-01-31 22:42:43.293 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ALL; 2025-01-31 22:42:43.294 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "none.such2" 2025-01-31 22:42:43.294 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET none.such2 = 'whiz bang'; 2025-01-31 22:42:43.294 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-31 22:42:43.294 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER ROLE regress_host_resource_admin SET lc_messages = 'POSIX'; 2025-01-31 22:42:43.299 UTC client backend[21670] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-31 22:42:43.299 UTC client backend[21670] 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-31 22:42:43.299 UTC client backend[21670] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-31 22:42:43.300 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-31 22:42:43.300 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-31 22:42:43.301 UTC client backend[21670] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-31 22:42:43.301 UTC client backend[21670] 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-31 22:42:43.301 UTC client backend[21670] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-31 22:42:43.302 UTC client backend[21670] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-31 22:42:43.302 UTC client backend[21670] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-31 22:42:43.305 UTC client backend[21670] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-31 22:42:43.305 UTC client backend[21670] 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-31 22:42:43.305 UTC client backend[21670] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-31 22:42:43.309 UTC postmaster[21628] LOG: received fast shutdown request 2025-01-31 22:42:43.309 UTC postmaster[21628] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2951, PID: 21628 0xaa7bf2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a0274 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89e255 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89d564 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres