2025-01-11 20:43:52.930 GMT postmaster[1664] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit
2025-01-11 20:43:52.932 GMT postmaster[1664] LOG:  listening on Unix socket "c:/cirrus/.s.PGSQL.40015"
2025-01-11 20:43:52.975 GMT startup[2532] LOG:  database system was shut down at 2025-01-11 20:40:52 GMT
2025-01-11 20:43:52.992 GMT postmaster[1664] LOG:  database system is ready to accept connections
2025-01-11 20:43:53.002 GMT client backend[7036] [unknown] FATAL:  the database system is starting up
2025-01-11 20:43:53.531 GMT client backend[6424] pg_regress/file_fdw ERROR:  permission denied to create foreign-data wrapper "file_fdw2"
2025-01-11 20:43:53.531 GMT client backend[6424] pg_regress/file_fdw HINT:  Must be superuser to create a foreign-data wrapper.
2025-01-11 20:43:53.531 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN DATA WRAPPER file_fdw2 HANDLER file_fdw_handler VALIDATOR file_fdw_validator;
2025-01-11 20:43:53.532 GMT client backend[6424] pg_regress/file_fdw ERROR:  permission denied for foreign-data wrapper file_fdw
2025-01-11 20:43:53.532 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE SERVER file_server2 FOREIGN DATA WRAPPER file_fdw;
2025-01-11 20:43:53.532 GMT client backend[6424] pg_regress/file_fdw ERROR:  permission denied for foreign server file_server
2025-01-11 20:43:53.532 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server;
2025-01-11 20:43:53.536 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY format "xml" not recognized
2025-01-11 20:43:53.536 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml');
2025-01-11 20:43:53.537 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-11 20:43:53.537 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', quote ':');
2025-01-11 20:43:53.537 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-11 20:43:53.537 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape ':');
2025-01-11 20:43:53.538 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot specify HEADER in BINARY mode
2025-01-11 20:43:53.538 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', header 'true');
2025-01-11 20:43:53.539 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-11 20:43:53.539 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', quote ':');
2025-01-11 20:43:53.540 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-11 20:43:53.540 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', escape ':');
2025-01-11 20:43:53.540 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-11 20:43:53.540 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-11 20:43:53.541 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-11 20:43:53.541 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape '-');
2025-01-11 20:43:53.542 GMT client backend[6424] pg_regress/file_fdw ERROR:  CSV quote character must not appear in the NULL specification
2025-01-11 20:43:53.542 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '-', null '=-=');
2025-01-11 20:43:53.542 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter character must not appear in the NULL specification
2025-01-11 20:43:53.542 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', null '=-=');
2025-01-11 20:43:53.543 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter and quote must be different
2025-01-11 20:43:53.543 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', quote '-');
2025-01-11 20:43:53.543 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter must be a single one-byte character
2025-01-11 20:43:53.543 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '---');
2025-01-11 20:43:53.544 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY quote must be a single one-byte character
2025-01-11 20:43:53.544 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '---');
2025-01-11 20:43:53.545 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY escape must be a single one-byte character
2025-01-11 20:43:53.545 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', escape '---');
2025-01-11 20:43:53.546 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "\"
2025-01-11 20:43:53.546 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '\');
2025-01-11 20:43:53.547 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "."
2025-01-11 20:43:53.547 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '.');
2025-01-11 20:43:53.548 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "1"
2025-01-11 20:43:53.548 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '1');
2025-01-11 20:43:53.549 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-11 20:43:53.549 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-11 20:43:53.549 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY delimiter cannot be newline or carriage return
2025-01-11 20:43:53.549 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '
	');
2025-01-11 20:43:53.550 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY null representation cannot use newline or carriage return
2025-01-11 20:43:53.550 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', null '
	');
2025-01-11 20:43:53.550 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY ON_ERROR "unsupported" not recognized
2025-01-11 20:43:53.550 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'unsupported');
2025-01-11 20:43:53.551 GMT client backend[6424] pg_regress/file_fdw ERROR:  only ON_ERROR STOP is allowed in BINARY mode
2025-01-11 20:43:53.551 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', on_error 'ignore');
2025-01-11 20:43:53.552 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY LOG_VERBOSITY "unsupported" not recognized
2025-01-11 20:43:53.552 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (log_verbosity 'unsupported');
2025-01-11 20:43:53.552 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY REJECT_LIMIT requires ON_ERROR to be set to IGNORE
2025-01-11 20:43:53.552 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (reject_limit '1');
2025-01-11 20:43:53.553 GMT client backend[6424] pg_regress/file_fdw ERROR:  REJECT_LIMIT (0) must be greater than zero
2025-01-11 20:43:53.553 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'ignore', reject_limit '0');
2025-01-11 20:43:53.554 GMT client backend[6424] pg_regress/file_fdw ERROR:  either filename or program is required for file_fdw foreign tables
2025-01-11 20:43:53.554 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server;
2025-01-11 20:43:53.563 GMT client backend[6424] pg_regress/file_fdw ERROR:  column name mismatch in header line field 1: got "1", expected "a"
2025-01-11 20:43:53.563 GMT client backend[6424] pg_regress/file_fdw CONTEXT:  COPY header_doesnt_match, line 1: "1,foo"
2025-01-11 20:43:53.563 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  SELECT * FROM header_doesnt_match;
2025-01-11 20:43:53.565 GMT client backend[6424] pg_regress/file_fdw ERROR:  COPY FORCE_NOT_NULL requires CSV mode
2025-01-11 20:43:53.565 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  SELECT * FROM text_csv;
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_not_null '*');
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_not_null '*');
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.567 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_not_null '*');
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_not_null '*');
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_null '*');
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_null '*');
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-11 20:43:53.568 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_null '*');
2025-01-11 20:43:53.569 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-11 20:43:53.569 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_null '*');
2025-01-11 20:43:53.574 GMT client backend[6424] pg_regress/file_fdw ERROR:  invalid input syntax for type real: "aaa"
2025-01-11 20:43:53.574 GMT client backend[6424] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 3, column b: "aaa"
2025-01-11 20:43:53.574 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-11 20:43:53.576 GMT client backend[6424] pg_regress/file_fdw ERROR:  skipped more than REJECT_LIMIT (1) rows due to data type incompatibility
2025-01-11 20:43:53.576 GMT client backend[6424] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 5, column b: "bbb"
2025-01-11 20:43:53.576 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-11 20:43:53.582 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-11 20:43:53.582 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  INSERT INTO agg_csv VALUES(1,2.0);
2025-01-11 20:43:53.582 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-11 20:43:53.582 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  UPDATE agg_csv SET a = 1;
2025-01-11 20:43:53.583 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-11 20:43:53.583 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  DELETE FROM agg_csv WHERE a = 100;
2025-01-11 20:43:53.583 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot truncate foreign table "agg_csv"
2025-01-11 20:43:53.583 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  TRUNCATE agg_csv;
2025-01-11 20:43:53.584 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-11 20:43:53.584 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  COPY agg_csv FROM STDIN;
2025-01-11 20:43:53.590 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-11 20:43:53.590 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  UPDATE agg SET a = 1;
2025-01-11 20:43:53.591 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-11 20:43:53.591 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  DELETE FROM agg WHERE a = 100;
2025-01-11 20:43:53.606 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-11 20:43:53.606 GMT client backend[6424] pg_regress/file_fdw CONTEXT:  COPY pt, line 2: "1,qux"
2025-01-11 20:43:53.606 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  COPY pt FROM 'C:/cirrus/contrib/file_fdw/data/list2.bad' with (format 'csv', delimiter ',');
2025-01-11 20:43:53.608 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-11 20:43:53.608 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  INSERT INTO pt VALUES (1, 'xyzzy');
2025-01-11 20:43:53.609 GMT client backend[6424] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-11 20:43:53.609 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  UPDATE pt set a = 1 where a = 2;
2025-01-11 20:43:53.622 GMT client backend[6424] pg_regress/file_fdw ERROR:  permission denied for foreign table agg_text
2025-01-11 20:43:53.622 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_text ORDER BY a;
2025-01-11 20:43:53.625 GMT client backend[6424] pg_regress/file_fdw ERROR:  permission denied to set the "filename" option of a file_fdw foreign table
2025-01-11 20:43:53.625 GMT client backend[6424] pg_regress/file_fdw DETAIL:  Only roles with privileges of the "pg_read_server_files" role may set this option.
2025-01-11 20:43:53.625 GMT client backend[6424] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text');
2025-01-11 20:43:53.752 GMT postmaster[1664] LOG:  received fast shutdown request
2025-01-11 20:43:53.752 GMT postmaster[1664] 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: 1664
abort() has been called