2025-01-31 22:21:22.641 GMT postmaster[5684] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit
2025-01-31 22:21:22.654 GMT postmaster[5684] LOG:  listening on Unix socket "c:/cirrus/.s.PGSQL.40015"
2025-01-31 22:21:22.684 GMT startup[5292] LOG:  database system was shut down at 2025-01-31 22:18:04 GMT
2025-01-31 22:21:22.707 GMT client backend[7736] [unknown] FATAL:  the database system is starting up
2025-01-31 22:21:22.714 GMT postmaster[5684] LOG:  database system is ready to accept connections
2025-01-31 22:21:23.357 GMT client backend[2484] pg_regress/file_fdw ERROR:  permission denied to create foreign-data wrapper "file_fdw2"
2025-01-31 22:21:23.357 GMT client backend[2484] pg_regress/file_fdw HINT:  Must be superuser to create a foreign-data wrapper.
2025-01-31 22:21:23.357 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN DATA WRAPPER file_fdw2 HANDLER file_fdw_handler VALIDATOR file_fdw_validator;
2025-01-31 22:21:23.358 GMT client backend[2484] pg_regress/file_fdw ERROR:  permission denied for foreign-data wrapper file_fdw
2025-01-31 22:21:23.358 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE SERVER file_server2 FOREIGN DATA WRAPPER file_fdw;
2025-01-31 22:21:23.358 GMT client backend[2484] pg_regress/file_fdw ERROR:  permission denied for foreign server file_server
2025-01-31 22:21:23.358 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server;
2025-01-31 22:21:23.362 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY format "xml" not recognized
2025-01-31 22:21:23.362 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml');
2025-01-31 22:21:23.362 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-31 22:21:23.362 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', quote ':');
2025-01-31 22:21:23.363 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 22:21:23.363 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape ':');
2025-01-31 22:21:23.364 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot specify HEADER in BINARY mode
2025-01-31 22:21:23.364 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', header 'true');
2025-01-31 22:21:23.365 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2025-01-31 22:21:23.365 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', quote ':');
2025-01-31 22:21:23.365 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 22:21:23.365 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', escape ':');
2025-01-31 22:21:23.366 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-31 22:21:23.366 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-31 22:21:23.366 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2025-01-31 22:21:23.366 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape '-');
2025-01-31 22:21:23.367 GMT client backend[2484] pg_regress/file_fdw ERROR:  CSV quote character must not appear in the NULL specification
2025-01-31 22:21:23.367 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '-', null '=-=');
2025-01-31 22:21:23.368 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter character must not appear in the NULL specification
2025-01-31 22:21:23.368 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', null '=-=');
2025-01-31 22:21:23.368 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter and quote must be different
2025-01-31 22:21:23.368 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', quote '-');
2025-01-31 22:21:23.369 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter must be a single one-byte character
2025-01-31 22:21:23.369 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '---');
2025-01-31 22:21:23.370 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY quote must be a single one-byte character
2025-01-31 22:21:23.370 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '---');
2025-01-31 22:21:23.371 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY escape must be a single one-byte character
2025-01-31 22:21:23.371 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', escape '---');
2025-01-31 22:21:23.372 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "\"
2025-01-31 22:21:23.372 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '\');
2025-01-31 22:21:23.372 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "."
2025-01-31 22:21:23.372 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '.');
2025-01-31 22:21:23.373 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "1"
2025-01-31 22:21:23.373 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '1');
2025-01-31 22:21:23.374 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2025-01-31 22:21:23.374 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2025-01-31 22:21:23.374 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY delimiter cannot be newline or carriage return
2025-01-31 22:21:23.374 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '
	');
2025-01-31 22:21:23.375 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY null representation cannot use newline or carriage return
2025-01-31 22:21:23.375 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', null '
	');
2025-01-31 22:21:23.375 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY ON_ERROR "unsupported" not recognized
2025-01-31 22:21:23.375 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'unsupported');
2025-01-31 22:21:23.376 GMT client backend[2484] pg_regress/file_fdw ERROR:  only ON_ERROR STOP is allowed in BINARY mode
2025-01-31 22:21:23.376 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', on_error 'ignore');
2025-01-31 22:21:23.377 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY LOG_VERBOSITY "unsupported" not recognized
2025-01-31 22:21:23.377 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (log_verbosity 'unsupported');
2025-01-31 22:21:23.377 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY REJECT_LIMIT requires ON_ERROR to be set to IGNORE
2025-01-31 22:21:23.377 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (reject_limit '1');
2025-01-31 22:21:23.378 GMT client backend[2484] pg_regress/file_fdw ERROR:  REJECT_LIMIT (0) must be greater than zero
2025-01-31 22:21:23.378 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'ignore', reject_limit '0');
2025-01-31 22:21:23.379 GMT client backend[2484] pg_regress/file_fdw ERROR:  either filename or program is required for file_fdw foreign tables
2025-01-31 22:21:23.379 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server;
2025-01-31 22:21:23.387 GMT client backend[2484] pg_regress/file_fdw ERROR:  column name mismatch in header line field 1: got "1", expected "a"
2025-01-31 22:21:23.387 GMT client backend[2484] pg_regress/file_fdw CONTEXT:  COPY header_doesnt_match, line 1: "1,foo"
2025-01-31 22:21:23.387 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  SELECT * FROM header_doesnt_match;
2025-01-31 22:21:23.389 GMT client backend[2484] pg_regress/file_fdw ERROR:  COPY FORCE_NOT_NULL requires CSV mode
2025-01-31 22:21:23.389 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  SELECT * FROM text_csv;
2025-01-31 22:21:23.390 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 22:21:23.390 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.390 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_not_null '*');
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_not_null '*');
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.391 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_not_null '*');
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_not_null '*');
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_null '*');
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_null '*');
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw HINT:  There are no valid options in this context.
2025-01-31 22:21:23.392 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_null '*');
2025-01-31 22:21:23.393 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid option "force_null"
2025-01-31 22:21:23.393 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_null '*');
2025-01-31 22:21:23.397 GMT client backend[2484] pg_regress/file_fdw ERROR:  invalid input syntax for type real: "aaa"
2025-01-31 22:21:23.397 GMT client backend[2484] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 3, column b: "aaa"
2025-01-31 22:21:23.397 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-31 22:21:23.399 GMT client backend[2484] pg_regress/file_fdw ERROR:  skipped more than REJECT_LIMIT (1) rows due to data type incompatibility
2025-01-31 22:21:23.399 GMT client backend[2484] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 5, column b: "bbb"
2025-01-31 22:21:23.399 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  INSERT INTO agg_csv VALUES(1,2.0);
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  UPDATE agg_csv SET a = 1;
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  DELETE FROM agg_csv WHERE a = 100;
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot truncate foreign table "agg_csv"
2025-01-31 22:21:23.405 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  TRUNCATE agg_csv;
2025-01-31 22:21:23.406 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2025-01-31 22:21:23.406 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  COPY agg_csv FROM STDIN;
2025-01-31 22:21:23.413 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2025-01-31 22:21:23.413 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  UPDATE agg SET a = 1;
2025-01-31 22:21:23.413 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2025-01-31 22:21:23.413 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  DELETE FROM agg WHERE a = 100;
2025-01-31 22:21:23.424 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 22:21:23.424 GMT client backend[2484] pg_regress/file_fdw CONTEXT:  COPY pt, line 2: "1,qux"
2025-01-31 22:21:23.424 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  COPY pt FROM 'C:/cirrus/contrib/file_fdw/data/list2.bad' with (format 'csv', delimiter ',');
2025-01-31 22:21:23.426 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 22:21:23.426 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  INSERT INTO pt VALUES (1, 'xyzzy');
2025-01-31 22:21:23.427 GMT client backend[2484] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2025-01-31 22:21:23.427 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  UPDATE pt set a = 1 where a = 2;
2025-01-31 22:21:23.439 GMT client backend[2484] pg_regress/file_fdw ERROR:  permission denied for foreign table agg_text
2025-01-31 22:21:23.439 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_text ORDER BY a;
2025-01-31 22:21:23.444 GMT client backend[2484] pg_regress/file_fdw ERROR:  permission denied to set the "filename" option of a file_fdw foreign table
2025-01-31 22:21:23.444 GMT client backend[2484] pg_regress/file_fdw DETAIL:  Only roles with privileges of the "pg_read_server_files" role may set this option.
2025-01-31 22:21:23.444 GMT client backend[2484] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text');
2025-01-31 22:21:23.711 GMT postmaster[5684] LOG:  received fast shutdown request
2025-01-31 22:21:23.711 GMT postmaster[5684] 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: 5684
abort() has been called