2025-01-25 11:16:05.939 GMT postmaster[4372] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-25 11:16:05.940 GMT postmaster[4372] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40083" 2025-01-25 11:16:05.969 GMT startup[1060] LOG: database system was shut down at 2025-01-25 11:11:57 GMT 2025-01-25 11:16:05.989 GMT client backend[4684] [unknown] FATAL: the database system is starting up 2025-01-25 11:16:05.998 GMT postmaster[4372] LOG: database system is ready to accept connections 2025-01-25 11:16:06.813 GMT client backend[1488] pg_regress/rolenames ERROR: CURRENT_USER cannot be used as a role name here at character 13 2025-01-25 11:16:06.813 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE current_user; 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames ERROR: CURRENT_ROLE cannot be used as a role name here at character 13 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE current_role; 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames ERROR: SESSION_USER cannot be used as a role name here at character 13 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE session_user; 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames ERROR: syntax error at or near "user" at character 13 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE user; 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames ERROR: syntax error at or near "all" at character 13 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE all; 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-25 11:16:06.814 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE public; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "public" is reserved at character 13 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE "public"; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE none; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "none" is reserved at character 13 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE "none"; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abc; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "pg_abc" is reserved 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abc"; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE pg_abcdef; 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames ERROR: role name "pg_abcdef" is reserved 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames DETAIL: Role names starting with "pg_" are reserved. 2025-01-25 11:16:06.815 GMT client backend[1488] pg_regress/rolenames STATEMENT: CREATE ROLE "pg_abcdef"; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE USER WITH LOGIN; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE ALL WITH REPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE SESSION_ROLE WITH NOREPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC WITH NOREPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE "public" WITH NOREPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE NONE WITH NOREPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE "none" WITH NOREPLICATION; 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.864 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent WITH NOREPLICATION; 2025-01-25 11:16:06.874 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-25 11:16:06.874 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER USER WITH LOGIN; 2025-01-25 11:16:06.874 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "WITH" at character 16 2025-01-25 11:16:06.874 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER ALL WITH REPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role "session_role" does not exist 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER SESSION_ROLE WITH NOREPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC WITH NOREPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER "public" WITH NOREPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER NONE WITH NOREPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER "none" WITH NOREPLICATION; 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.875 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER nonexistent WITH NOREPLICATION; 2025-01-25 11:16:06.885 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-25 11:16:06.885 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE USER SET application_name to 'BOOM'; 2025-01-25 11:16:06.886 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.886 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE PUBLIC SET application_name to 'BOMB'; 2025-01-25 11:16:06.886 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.886 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER ROLE nonexistent SET application_name to 'BOMB'; 2025-01-25 11:16:06.894 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 12 2025-01-25 11:16:06.894 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER USER SET application_name to 'BOOM'; 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER PUBLIC SET application_name to 'BOMB'; 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 12 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER NONE SET application_name to 'BOMB'; 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.895 GMT client backend[2720] pg_regress/rolenames STATEMENT: ALTER USER nonexistent SET application_name to 'BOMB'; 2025-01-25 11:16:06.899 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 40 2025-01-25 11:16:06.899 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION USER; 2025-01-25 11:16:06.899 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.899 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION PUBLIC; 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION "public"; 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 40 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION NONE; 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.900 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA newschemax AUTHORIZATION nonexistent; 2025-01-25 11:16:06.902 GMT client backend[2720] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 54 2025-01-25 11:16:06.902 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION USER; 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION PUBLIC; 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION "public"; 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames ERROR: role name "none" is reserved at character 54 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION NONE; 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:06.903 GMT client backend[2720] pg_regress/rolenames STATEMENT: CREATE SCHEMA IF NOT EXISTS newschemax AUTHORIZATION nonexistent; 2025-01-25 11:16:07.005 GMT client backend[6656] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 31 2025-01-25 11:16:07.005 GMT client backend[6656] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO USER; 2025-01-25 11:16:07.005 GMT client backend[6656] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:07.005 GMT client backend[6656] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO PUBLIC; 2025-01-25 11:16:07.006 GMT client backend[6656] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:07.006 GMT client backend[6656] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO "public"; 2025-01-25 11:16:07.006 GMT client backend[6656] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:07.006 GMT client backend[6656] pg_regress/rolenames STATEMENT: ALTER TABLE testtab7 OWNER TO nonexistent; 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 41 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO USER; 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO PUBLIC; 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames ERROR: role "public" does not exist 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO "public"; 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:07.181 GMT client backend[4428] pg_regress/rolenames STATEMENT: ALTER AGGREGATE testagg6(int2) OWNER TO nonexistent; 2025-01-25 11:16:07.251 GMT client backend[4428] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:07.251 GMT client backend[4428] pg_regress/rolenames STATEMENT: CREATE USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (user 'nonexistent'); 2025-01-25 11:16:07.255 GMT client backend[4428] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:07.255 GMT client backend[4428] pg_regress/rolenames STATEMENT: ALTER USER MAPPING FOR nonexistent SERVER sv10 OPTIONS (SET user 'nonexistent_alt'); 2025-01-25 11:16:07.261 GMT client backend[4428] pg_regress/rolenames ERROR: role "nonexistent" does not exist 2025-01-25 11:16:07.261 GMT client backend[4428] pg_regress/rolenames STATEMENT: DROP USER MAPPING FOR nonexistent SERVER sv10; 2025-01-25 11:16:07.295 GMT client backend[4428] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 52 2025-01-25 11:16:07.295 GMT client backend[4428] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO USER; 2025-01-25 11:16:07.296 GMT client backend[4428] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-25 11:16:07.296 GMT client backend[4428] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO NONE; 2025-01-25 11:16:07.297 GMT client backend[4428] pg_regress/rolenames ERROR: role name "none" is reserved at character 52 2025-01-25 11:16:07.297 GMT client backend[4428] pg_regress/rolenames STATEMENT: GRANT ALL PRIVILEGES ON FUNCTION testagga(int2) TO "none"; 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames ERROR: syntax error at or near "USER" at character 55 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM USER; 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM NONE; 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames ERROR: role name "none" is reserved at character 55 2025-01-25 11:16:07.303 GMT client backend[4428] pg_regress/rolenames STATEMENT: REVOKE ALL PRIVILEGES ON FUNCTION testagga(int2) FROM "none"; 2025-01-25 11:16:07.313 GMT client backend[4428] pg_regress/rolenames ERROR: permission denied to examine "session_preload_libraries" 2025-01-25 11:16:07.313 GMT client backend[4428] pg_regress/rolenames DETAIL: Only roles with privileges of the "pg_read_all_settings" role may examine this parameter. 2025-01-25 11:16:07.313 GMT client backend[4428] pg_regress/rolenames STATEMENT: SHOW session_preload_libraries; 2025-01-25 11:16:07.313 GMT client backend[4428] pg_regress/rolenames ERROR: current transaction is aborted, commands ignored until end of transaction block 2025-01-25 11:16:07.313 GMT client backend[4428] pg_regress/rolenames STATEMENT: RESET SESSION AUTHORIZATION; 2025-01-25 11:16:08.014 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied to create "pg_catalog.test" 2025-01-25 11:16:08.014 GMT client backend[6712] pg_regress/alter_system_table DETAIL: System catalog modifications are currently disallowed. 2025-01-25 11:16:08.014 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE TABLE pg_catalog.test (a int); 2025-01-25 11:16:08.015 GMT client backend[6712] pg_regress/alter_system_table ERROR: column "b" has pseudo-type anyarray 2025-01-25 11:16:08.015 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE TABLE t1x (a int, b anyarray); 2025-01-25 11:16:08.015 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_namespace" is a system catalog 2025-01-25 11:16:08.015 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_namespace ADD CONSTRAINT foo UNIQUE USING INDEX pg_namespace_nspname_index; 2025-01-25 11:16:08.017 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-25 11:16:08.017 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 1, 'foo'); 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE POLICY foo ON pg_description FOR SELECT USING (description NOT LIKE 'secret%'); 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: unacceptable schema name "pg_foo" 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system schemas. 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE SCHEMA pg_foo; 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: TRUNCATE pg_description; 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME COLUMN description TO comment; 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET NOT NULL; 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.018 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description ALTER COLUMN description SET STATISTICS -1; 2025-01-25 11:16:08.020 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.020 GMT client backend[6712] 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-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE INDEX pg_description_test_index ON pg_description (description); 2025-01-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description RENAME TO pg_comment; 2025-01-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.021 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TABLE pg_description SET SCHEMA public; 2025-01-25 11:16:08.022 GMT client backend[6712] pg_regress/alter_system_table ERROR: unacceptable tablespace name "pg_foo" 2025-01-25 11:16:08.022 GMT client backend[6712] pg_regress/alter_system_table DETAIL: The prefix "pg_" is reserved for system tablespaces. 2025-01-25 11:16:08.022 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER TRIGGER t1 ON pg_description RENAME TO t2; 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE RULE r1 AS ON INSERT TO pg_description DO INSTEAD NOTHING; 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.023 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: ALTER RULE r1 ON pg_description RENAME TO r2; 2025-01-25 11:16:08.025 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied: "pg_description" is a system catalog 2025-01-25 11:16:08.025 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: DROP RULE r2 ON pg_description; 2025-01-25 11:16:08.035 GMT client backend[6712] pg_regress/alter_system_table ERROR: permission denied for table pg_description 2025-01-25 11:16:08.035 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: INSERT INTO pg_description (objoid, classoid, objsubid, description) VALUES (0, 0, 3, 'foo'); 2025-01-25 11:16:08.038 GMT client backend[6712] pg_regress/alter_system_table ERROR: cannot drop table pg_description because it is required by the database system 2025-01-25 11:16:08.038 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: DROP TABLE pg_description; 2025-01-25 11:16:08.066 GMT client backend[6712] pg_regress/alter_system_table ERROR: directory "/no/such/location" does not exist 2025-01-25 11:16:08.066 GMT client backend[6712] pg_regress/alter_system_table STATEMENT: CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; 2025-01-25 11:16:08.259 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-25 11:16:08.259 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SET ignore_system_indexes = OFF; 2025-01-25 11:16:08.259 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "ignore_system_indexes" cannot be set after connection start 2025-01-25 11:16:08.259 GMT client backend[1800] pg_regress/guc_privs STATEMENT: RESET ignore_system_indexes; 2025-01-25 11:16:08.266 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-25 11:16:08.266 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SET block_size = 50; 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs STATEMENT: RESET block_size; 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET block_size = 50; 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "block_size" cannot be changed 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET block_size; 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SET autovacuum_freeze_max_age = 1000050000; 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "autovacuum_freeze_max_age" cannot be changed without restarting the server 2025-01-25 11:16:08.267 GMT client backend[1800] pg_regress/guc_privs STATEMENT: RESET autovacuum_freeze_max_age; 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET config_file = '/usr/local/data/postgresql.conf'; 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "config_file" cannot be changed 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET config_file; 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SET autovacuum = OFF; 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "autovacuum" cannot be changed now 2025-01-25 11:16:08.269 GMT client backend[1800] pg_regress/guc_privs STATEMENT: RESET autovacuum; 2025-01-25 11:16:08.277 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-25 11:16:08.277 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SET jit_debugging_support = OFF; 2025-01-25 11:16:08.278 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "jit_debugging_support" cannot be set after connection start 2025-01-25 11:16:08.278 GMT client backend[1800] pg_regress/guc_privs STATEMENT: RESET jit_debugging_support; 2025-01-25 11:16:08.282 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-25 11:16:08.282 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ssl_renegotiation_limit = 0; 2025-01-25 11:16:08.283 GMT client backend[1800] pg_regress/guc_privs ERROR: parameter "ssl_renegotiation_limit" cannot be changed 2025-01-25 11:16:08.283 GMT client backend[1800] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ssl_renegotiation_limit; 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-25 11:16:08.285 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-25 11:16:08.295 GMT client backend[1800] pg_regress/guc_privs ERROR: unrecognized configuration parameter "none.such" 2025-01-25 11:16:08.295 GMT client backend[1800] pg_regress/guc_privs STATEMENT: SHOW none.such; 2025-01-25 11:16:08.295 GMT postmaster[4372] LOG: received SIGHUP, reloading configuration files 2025-01-25 11:16:08.297 GMT postmaster[4372] LOG: parameter "none.such" changed to "whiz bang" 2025-01-25 11:16:08.345 GMT client backend[2196] pg_regress/guc_privs ERROR: unrecognized configuration parameter "no_such_guc" 2025-01-25 11:16:08.345 GMT client backend[2196] pg_regress/guc_privs STATEMENT: GRANT ALL ON PARAMETER no_such_guc TO regress_host_resource_admin; 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs ERROR: unrecognized privilege type: "SELECT" 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'SELECT, UPDATE, CREATE'); 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs ERROR: unrecognized privilege type: "USAGE" 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'USAGE'); 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER" 2025-01-25 11:16:08.354 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER'); 2025-01-25 11:16:08.355 GMT client backend[2196] pg_regress/guc_privs ERROR: unrecognized privilege type: "WHATEVER WITH GRANT OPTION" 2025-01-25 11:16:08.355 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SELECT has_parameter_privilege('regress_host_resource_admin', 'work_mem', 'WHATEVER WITH GRANT OPTION'); 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "ignore_system_indexes" 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET ignore_system_indexes = OFF; 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_multixact_freeze_max_age" 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET autovacuum_multixact_freeze_max_age; 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SET jit_provider = 'llvmjit'; 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs ERROR: parameter "jit_provider" cannot be changed without restarting the server 2025-01-25 11:16:08.360 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SELECT set_config ('jit_provider', 'llvmjit', true); 2025-01-25 11:16:08.363 GMT client backend[2196] pg_regress/guc_privs ERROR: parameter "autovacuum_work_mem" cannot be changed now 2025-01-25 11:16:08.363 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SET autovacuum_work_mem = 50; 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs STATEMENT: SET lc_messages = 'C'; 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs STATEMENT: RESET lc_messages; 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET lc_messages = 'C'; 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-25 11:16:08.386 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET lc_messages; 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to perform ALTER SYSTEM RESET ALL 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM RESET ALL; 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "none.such2" 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET none.such2 = 'whiz bang'; 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "lc_messages" 2025-01-25 11:16:08.389 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER ROLE regress_host_resource_admin SET lc_messages = 'POSIX'; 2025-01-25 11:16:08.399 GMT client backend[2196] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-25 11:16:08.399 GMT client backend[2196] 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-25 11:16:08.399 GMT client backend[2196] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-25 11:16:08.402 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-25 11:16:08.402 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-25 11:16:08.403 GMT client backend[2196] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-25 11:16:08.403 GMT client backend[2196] 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-25 11:16:08.403 GMT client backend[2196] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-25 11:16:08.404 GMT client backend[2196] pg_regress/guc_privs ERROR: permission denied to set parameter "autovacuum_work_mem" 2025-01-25 11:16:08.404 GMT client backend[2196] pg_regress/guc_privs STATEMENT: ALTER SYSTEM SET autovacuum_work_mem = 32; 2025-01-25 11:16:08.411 GMT client backend[2196] pg_regress/guc_privs ERROR: role "regress_host_resource_admin" cannot be dropped because some objects depend on it 2025-01-25 11:16:08.411 GMT client backend[2196] 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-25 11:16:08.411 GMT client backend[2196] pg_regress/guc_privs STATEMENT: DROP ROLE regress_host_resource_admin; 2025-01-25 11:16:08.534 GMT postmaster[4372] LOG: received fast shutdown request 2025-01-25 11:16:08.535 GMT postmaster[4372] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2964, PID: 4372 abort() has been called