2024-12-18 07:15:17.183 UTC postmaster[19345] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-12-18 07:15:17.183 UTC postmaster[19345] LOG:  listening on Unix socket "/tmp/pg_regress-4I1sPT/.s.PGSQL.40016"
2024-12-18 07:15:17.185 UTC startup[19348] LOG:  database system was shut down at 2024-12-18 07:15:17 UTC
2024-12-18 07:15:17.186 UTC postmaster[19345] LOG:  database system is ready to accept connections
2024-12-18 07:15:17.269 UTC client backend[19356] pg_regress/file_fdw ERROR:  permission denied to create foreign-data wrapper "file_fdw2"
2024-12-18 07:15:17.269 UTC client backend[19356] pg_regress/file_fdw HINT:  Must be superuser to create a foreign-data wrapper.
2024-12-18 07:15:17.269 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN DATA WRAPPER file_fdw2 HANDLER file_fdw_handler VALIDATOR file_fdw_validator;
2024-12-18 07:15:17.270 UTC client backend[19356] pg_regress/file_fdw ERROR:  permission denied for foreign-data wrapper file_fdw
2024-12-18 07:15:17.270 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE SERVER file_server2 FOREIGN DATA WRAPPER file_fdw;
2024-12-18 07:15:17.270 UTC client backend[19356] pg_regress/file_fdw ERROR:  permission denied for foreign server file_server
2024-12-18 07:15:17.270 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR regress_file_fdw_user SERVER file_server;
2024-12-18 07:15:17.272 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY format "xml" not recognized
2024-12-18 07:15:17.272 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'xml');
2024-12-18 07:15:17.272 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2024-12-18 07:15:17.272 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', quote ':');
2024-12-18 07:15:17.273 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2024-12-18 07:15:17.273 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape ':');
2024-12-18 07:15:17.273 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot specify HEADER in BINARY mode
2024-12-18 07:15:17.273 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', header 'true');
2024-12-18 07:15:17.274 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY QUOTE requires CSV mode
2024-12-18 07:15:17.274 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', quote ':');
2024-12-18 07:15:17.275 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2024-12-18 07:15:17.275 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', escape ':');
2024-12-18 07:15:17.275 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2024-12-18 07:15:17.275 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2024-12-18 07:15:17.276 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY ESCAPE requires CSV mode
2024-12-18 07:15:17.276 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', escape '-');
2024-12-18 07:15:17.276 UTC client backend[19356] pg_regress/file_fdw ERROR:  CSV quote character must not appear in the NULL specification
2024-12-18 07:15:17.276 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '-', null '=-=');
2024-12-18 07:15:17.277 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter character must not appear in the NULL specification
2024-12-18 07:15:17.277 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', null '=-=');
2024-12-18 07:15:17.277 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter and quote must be different
2024-12-18 07:15:17.277 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '-', quote '-');
2024-12-18 07:15:17.278 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter must be a single one-byte character
2024-12-18 07:15:17.278 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '---');
2024-12-18 07:15:17.278 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY quote must be a single one-byte character
2024-12-18 07:15:17.278 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', quote '---');
2024-12-18 07:15:17.279 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY escape must be a single one-byte character
2024-12-18 07:15:17.279 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', escape '---');
2024-12-18 07:15:17.279 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "\"
2024-12-18 07:15:17.279 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '\');
2024-12-18 07:15:17.280 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "."
2024-12-18 07:15:17.280 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '.');
2024-12-18 07:15:17.280 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "1"
2024-12-18 07:15:17.280 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter '1');
2024-12-18 07:15:17.281 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be "a"
2024-12-18 07:15:17.281 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'text', delimiter 'a');
2024-12-18 07:15:17.282 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY delimiter cannot be newline or carriage return
2024-12-18 07:15:17.282 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', delimiter '
	');
2024-12-18 07:15:17.282 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY null representation cannot use newline or carriage return
2024-12-18 07:15:17.282 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'csv', null '
	');
2024-12-18 07:15:17.283 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY ON_ERROR "unsupported" not recognized
2024-12-18 07:15:17.283 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'unsupported');
2024-12-18 07:15:17.283 UTC client backend[19356] pg_regress/file_fdw ERROR:  only ON_ERROR STOP is allowed in BINARY mode
2024-12-18 07:15:17.283 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (format 'binary', on_error 'ignore');
2024-12-18 07:15:17.284 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY LOG_VERBOSITY "unsupported" not recognized
2024-12-18 07:15:17.284 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (log_verbosity 'unsupported');
2024-12-18 07:15:17.284 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY REJECT_LIMIT requires ON_ERROR to be set to IGNORE
2024-12-18 07:15:17.284 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (reject_limit '1');
2024-12-18 07:15:17.285 UTC client backend[19356] pg_regress/file_fdw ERROR:  REJECT_LIMIT (0) must be greater than zero
2024-12-18 07:15:17.285 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (on_error 'ignore', reject_limit '0');
2024-12-18 07:15:17.285 UTC client backend[19356] pg_regress/file_fdw ERROR:  either filename or program is required for file_fdw foreign tables
2024-12-18 07:15:17.285 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server;
2024-12-18 07:15:17.292 UTC client backend[19356] pg_regress/file_fdw ERROR:  column name mismatch in header line field 1: got "1", expected "a"
2024-12-18 07:15:17.292 UTC client backend[19356] pg_regress/file_fdw CONTEXT:  COPY header_doesnt_match, line 1: "1,foo"
2024-12-18 07:15:17.292 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  SELECT * FROM header_doesnt_match;
2024-12-18 07:15:17.293 UTC client backend[19356] pg_regress/file_fdw ERROR:  COPY FORCE_NOT_NULL requires CSV mode
2024-12-18 07:15:17.293 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  SELECT * FROM text_csv;
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_not_null '*');
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_not_null '*');
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.294 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_not_null '*');
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_not_null"
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_not_null '*');
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_null"
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN DATA WRAPPER file_fdw OPTIONS (ADD force_null '*');
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_null"
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  ALTER SERVER file_server OPTIONS (ADD force_null '*');
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_null"
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw HINT:  There are no valid options in this context.
2024-12-18 07:15:17.295 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE USER MAPPING FOR public SERVER file_server OPTIONS (force_null '*');
2024-12-18 07:15:17.296 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid option "force_null"
2024-12-18 07:15:17.296 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  CREATE FOREIGN TABLE tbl () SERVER file_server OPTIONS (force_null '*');
2024-12-18 07:15:17.300 UTC client backend[19356] pg_regress/file_fdw ERROR:  invalid input syntax for type real: "aaa"
2024-12-18 07:15:17.300 UTC client backend[19356] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 3, column b: "aaa"
2024-12-18 07:15:17.300 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2024-12-18 07:15:17.302 UTC client backend[19356] pg_regress/file_fdw ERROR:  skipped more than REJECT_LIMIT (1) rows due to data type incompatibility
2024-12-18 07:15:17.302 UTC client backend[19356] pg_regress/file_fdw CONTEXT:  COPY agg_bad, line 5, column b: "bbb"
2024-12-18 07:15:17.302 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_bad;
2024-12-18 07:15:17.306 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2024-12-18 07:15:17.306 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  INSERT INTO agg_csv VALUES(1,2.0);
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  UPDATE agg_csv SET a = 1;
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  DELETE FROM agg_csv WHERE a = 100;
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot truncate foreign table "agg_csv"
2024-12-18 07:15:17.307 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  TRUNCATE agg_csv;
2024-12-18 07:15:17.308 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot insert into foreign table "agg_csv"
2024-12-18 07:15:17.308 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  COPY agg_csv FROM STDIN;
2024-12-18 07:15:17.313 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot update foreign table "agg_csv"
2024-12-18 07:15:17.313 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  UPDATE agg SET a = 1;
2024-12-18 07:15:17.313 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot delete from foreign table "agg_csv"
2024-12-18 07:15:17.313 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  DELETE FROM agg WHERE a = 100;
2024-12-18 07:15:17.321 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2024-12-18 07:15:17.321 UTC client backend[19356] pg_regress/file_fdw CONTEXT:  COPY pt, line 2: "1,qux"
2024-12-18 07:15:17.321 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  COPY pt FROM '/tmp/cirrus-ci-build/contrib/file_fdw/data/list2.bad' with (format 'csv', delimiter ',');
2024-12-18 07:15:17.322 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2024-12-18 07:15:17.322 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  INSERT INTO pt VALUES (1, 'xyzzy');
2024-12-18 07:15:17.323 UTC client backend[19356] pg_regress/file_fdw ERROR:  cannot insert into foreign table "p1"
2024-12-18 07:15:17.323 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  UPDATE pt set a = 1 where a = 2;
2024-12-18 07:15:17.333 UTC client backend[19356] pg_regress/file_fdw ERROR:  permission denied for foreign table agg_text
2024-12-18 07:15:17.333 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  SELECT * FROM agg_text ORDER BY a;
2024-12-18 07:15:17.335 UTC client backend[19356] pg_regress/file_fdw ERROR:  permission denied to set the "filename" option of a file_fdw foreign table
2024-12-18 07:15:17.335 UTC client backend[19356] pg_regress/file_fdw DETAIL:  Only roles with privileges of the "pg_read_server_files" role may set this option.
2024-12-18 07:15:17.335 UTC client backend[19356] pg_regress/file_fdw STATEMENT:  ALTER FOREIGN TABLE agg_text OPTIONS (SET format 'text');
2024-12-18 07:15:17.343 UTC postmaster[19345] LOG:  received fast shutdown request
2024-12-18 07:15:17.343 UTC postmaster[19345] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 19345
0xaa4ae2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89fc67 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89e169 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89d544 <PostmasterMain+0x11c4> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres