2025-01-31 07:48:11.055 GMT postmaster[1320] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit
2025-01-31 07:48:11.057 GMT postmaster[1320] LOG:  listening on Unix socket "c:/cirrus/.s.PGSQL.40015"
2025-01-31 07:48:11.090 GMT startup[7848] LOG:  database system was shut down at 2025-01-31 07:44:57 GMT
2025-01-31 07:48:11.118 GMT client backend[7032] [unknown] FATAL:  the database system is starting up
2025-01-31 07:48:11.165 GMT postmaster[1320] LOG:  database system is ready to accept connections
2025-01-31 07:48:11.722 GMT client backend[4792] pg_regress/file_fdw ERROR:  permission denied to create foreign-data wrapper "file_fdw2"
2025-01-31 07:48:11.722 GMT client backend[4792] pg_regress/file_fdw HINT:  Must be superuser to create a foreign-data wrapper.
2025-01-31 07:48:11.722 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN DATA WRAPPER file_fdw2 HANDLER file_fdw_handler VALIDATOR file_fdw_validator;
2025-01-31 07:48:11.723 GMT client backend[4792] pg_regress/file_fdw ERROR:  permission denied for foreign-data wrapper file_fdw
2025-01-31 07:48:11.723 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE SERVER file_server2 FOREIGN DATA WRAPPER file_fdw;
2025-01-31 07:48:11.723 GMT client backend[4792] pg_regress/file_fdw ERROR:  permission denied for foreign server file_server
2025-01-31 07:48:11.723 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server;
2025-01-31 07:48:11.727 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY format "xml" not recognized
2025-01-31 07:48:11.727 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml');
2025-01-31 07:48:11.728 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-31 07:48:11.728 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', quote ':');
2025-01-31 07:48:11.729 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 07:48:11.729 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape ':');
2025-01-31 07:48:11.730 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot specify HEADER in BINARY mode
2025-01-31 07:48:11.730 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', header 'true');
2025-01-31 07:48:11.730 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-31 07:48:11.730 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', quote ':');
2025-01-31 07:48:11.731 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 07:48:11.731 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', escape ':');
2025-01-31 07:48:11.732 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-31 07:48:11.732 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-31 07:48:11.732 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 07:48:11.732 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape '-');
2025-01-31 07:48:11.733 GMT client backend[4792] pg_regress/file_fdw ERROR:  CSV quote character must not appear in the NULL specification
2025-01-31 07:48:11.733 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '-', null '=-=');
2025-01-31 07:48:11.734 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter character must not appear in the NULL specification
2025-01-31 07:48:11.734 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', null '=-=');
2025-01-31 07:48:11.734 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter and quote must be different
2025-01-31 07:48:11.734 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', quote '-');
2025-01-31 07:48:11.735 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter must be a single one-byte character
2025-01-31 07:48:11.735 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '---');
2025-01-31 07:48:11.736 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY quote must be a single one-byte character
2025-01-31 07:48:11.736 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '---');
2025-01-31 07:48:11.737 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY escape must be a single one-byte character
2025-01-31 07:48:11.737 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', escape '---');
2025-01-31 07:48:11.738 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "\"
2025-01-31 07:48:11.738 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '\');
2025-01-31 07:48:11.738 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "."
2025-01-31 07:48:11.738 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '.');
2025-01-31 07:48:11.739 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "1"
2025-01-31 07:48:11.739 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '1');
2025-01-31 07:48:11.740 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-31 07:48:11.740 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-31 07:48:11.740 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY delimiter cannot be newline or carriage return
2025-01-31 07:48:11.740 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '
	');
2025-01-31 07:48:11.741 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY null representation cannot use newline or carriage return
2025-01-31 07:48:11.741 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', null '
	');
2025-01-31 07:48:11.742 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY ON_ERROR "unsupported" not recognized
2025-01-31 07:48:11.742 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'unsupported');
2025-01-31 07:48:11.742 GMT client backend[4792] pg_regress/file_fdw ERROR:  only ON_ERROR STOP is allowed in BINARY mode
2025-01-31 07:48:11.742 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', on_error 'ignore');
2025-01-31 07:48:11.743 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY LOG_VERBOSITY "unsupported" not recognized
2025-01-31 07:48:11.743 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (log_verbosity 'unsupported');
2025-01-31 07:48:11.744 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY REJECT_LIMIT requires ON_ERROR to be set to IGNORE
2025-01-31 07:48:11.744 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (reject_limit '1');
2025-01-31 07:48:11.744 GMT client backend[4792] pg_regress/file_fdw ERROR:  REJECT_LIMIT (0) must be greater than zero
2025-01-31 07:48:11.744 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'ignore', reject_limit '0');
2025-01-31 07:48:11.745 GMT client backend[4792] pg_regress/file_fdw ERROR:  either filename or program is required for file_fdw foreign tables
2025-01-31 07:48:11.745 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server;
2025-01-31 07:48:11.755 GMT client backend[4792] pg_regress/file_fdw ERROR:  column name mismatch in header line field 1: got "1", expected "a"
2025-01-31 07:48:11.755 GMT client backend[4792] pg_regress/file_fdw CONTEXT:  COPY header_doesnt_match, line 1: "1,foo"
2025-01-31 07:48:11.755 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  SELECT * FROM header_doesnt_match;
2025-01-31 07:48:11.757 GMT client backend[4792] pg_regress/file_fdw ERROR:  COPY FORCE_NOT_NULL requires CSV mode
2025-01-31 07:48:11.757 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  SELECT * FROM text_csv;
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_not_null '*');
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_not_null '*');
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.759 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_not_null '*');
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_not_null '*');
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_null '*');
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_null '*');
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 07:48:11.760 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_null '*');
2025-01-31 07:48:11.761 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 07:48:11.761 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_null '*');
2025-01-31 07:48:11.766 GMT client backend[4792] pg_regress/file_fdw ERROR:  invalid input syntax for type real: "aaa"
2025-01-31 07:48:11.766 GMT client backend[4792] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 3, column b: "aaa"
2025-01-31 07:48:11.766 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-31 07:48:11.768 GMT client backend[4792] pg_regress/file_fdw ERROR:  skipped more than REJECT_LIMIT (1) rows due to data type incompatibility
2025-01-31 07:48:11.768 GMT client backend[4792] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 5, column b: "bbb"
2025-01-31 07:48:11.768 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-31 07:48:11.774 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-31 07:48:11.774 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  INSERT INTO agg_csv VALUES(1,2.0);
2025-01-31 07:48:11.774 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-31 07:48:11.774 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  UPDATE agg_csv SET a = 1;
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  DELETE FROM agg_csv WHERE a = 100;
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot truncate foreign table "agg_csv"
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  TRUNCATE agg_csv;
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-31 07:48:11.775 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  COPY agg_csv FROM STDIN;
2025-01-31 07:48:11.783 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-31 07:48:11.783 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  UPDATE agg SET a = 1;
2025-01-31 07:48:11.783 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-31 07:48:11.783 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  DELETE FROM agg WHERE a = 100;
2025-01-31 07:48:11.795 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 07:48:11.795 GMT client backend[4792] pg_regress/file_fdw CONTEXT:  COPY pt, line 2: "1,qux"
2025-01-31 07:48:11.795 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  COPY pt FROM 'C:/cirrus/contrib/file_fdw/data/list2.bad' with (format 'csv', delimiter ',');
2025-01-31 07:48:11.797 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 07:48:11.797 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  INSERT INTO pt VALUES (1, 'xyzzy');
2025-01-31 07:48:11.798 GMT client backend[4792] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 07:48:11.798 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  UPDATE pt set a = 1 where a = 2;
2025-01-31 07:48:11.810 GMT client backend[4792] pg_regress/file_fdw ERROR:  permission denied for foreign table agg_text
2025-01-31 07:48:11.810 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_text ORDER BY a;
2025-01-31 07:48:11.814 GMT client backend[4792] pg_regress/file_fdw ERROR:  permission denied to set the "filename" option of a file_fdw foreign table
2025-01-31 07:48:11.814 GMT client backend[4792] pg_regress/file_fdw DETAIL:  Only roles with privileges of the "pg_read_server_files" role may set this option.
2025-01-31 07:48:11.814 GMT client backend[4792] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text');
2025-01-31 07:48:12.798 GMT postmaster[1320] LOG:  received fast shutdown request
2025-01-31 07:48:12.798 GMT postmaster[1320] 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: 1320
abort() has been called