2024-11-30 22:45:52.093 UTC postmaster[19138] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-11-30 22:45:52.093 UTC postmaster[19138] LOG: listening on Unix socket "/tmp/pg_regress-bHrJka/.s.PGSQL.40012" 2024-11-30 22:45:52.094 UTC startup[19141] LOG: database system was shut down at 2024-11-30 22:45:52 UTC 2024-11-30 22:45:52.095 UTC postmaster[19138] LOG: database system is ready to accept connections 2024-11-30 22:45:52.193 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.193 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_insert('foo','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}','{"99", "xyz", "{za0,zb0,zc0}"}'); 2024-11-30 22:45:52.194 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.194 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_update('foo','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}','{"99", "xyz", "{za0,zb0,zc0}"}'); 2024-11-30 22:45:52.194 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.194 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_delete('foo','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}'); 2024-11-30 22:45:52.200 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.200 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_insert('foo_1','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}','{"99", "xyz", "{za0,zb0,zc0}"}'); 2024-11-30 22:45:52.201 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.201 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_update('foo_1','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}','{"99", "xyz", "{za0,zb0,zc0}"}'); 2024-11-30 22:45:52.201 UTC client backend[19149] pg_regress/dblink ERROR: invalid attribute number 4 2024-11-30 22:45:52.201 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_build_sql_delete('foo_1','1 2 3 4',4,'{"0", "a", "{a0,b0,c0}"}'); 2024-11-30 22:45:52.212 UTC client backend[19149] pg_regress/dblink ERROR: connection not available 2024-11-30 22:45:52.212 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink('SELECT * FROM foo') AS t(a int, b text, c text[]) WHERE t.a > 7; 2024-11-30 22:45:52.302 UTC client backend[19153] pg_regress ERROR: relation "foobar" does not exist at character 49 2024-11-30 22:45:52.302 UTC client backend[19153] pg_regress STATEMENT: DECLARE rmt_foo_cursor CURSOR FOR SELECT * FROM foobar 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress ERROR: cursor "rmt_foobar_cursor" does not exist 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress STATEMENT: FETCH 4 FROM rmt_foobar_cursor 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress ERROR: cursor "rmt_foobar_cursor" does not exist 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress STATEMENT: CLOSE rmt_foobar_cursor 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress ERROR: cursor "rmt_foo_cursor" does not exist 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress STATEMENT: FETCH 4 FROM rmt_foo_cursor 2024-11-30 22:45:52.306 UTC client backend[19149] pg_regress/dblink ERROR: cursor "rmt_foo_cursor" does not exist 2024-11-30 22:45:52.306 UTC client backend[19149] pg_regress/dblink CONTEXT: while fetching from cursor "rmt_foo_cursor" on unnamed dblink connection 2024-11-30 22:45:52.306 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink_fetch('rmt_foo_cursor',4) AS t(a int, b text, c text[]); 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress ERROR: cursor "rmt_foo_cursor" does not exist 2024-11-30 22:45:52.306 UTC client backend[19153] pg_regress STATEMENT: FETCH 4 FROM rmt_foo_cursor 2024-11-30 22:45:52.307 UTC client backend[19149] pg_regress/dblink ERROR: connection not available 2024-11-30 22:45:52.307 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink('SELECT * FROM foo') AS t(a int, b text, c text[]) WHERE t.a > 7; 2024-11-30 22:45:52.314 UTC client backend[19155] pg_regress ERROR: relation "foobar" does not exist at character 15 2024-11-30 22:45:52.314 UTC client backend[19155] pg_regress STATEMENT: SELECT * FROM foobar 2024-11-30 22:45:52.316 UTC client backend[19155] pg_regress ERROR: relation "foobar" does not exist at character 8 2024-11-30 22:45:52.316 UTC client backend[19155] pg_regress STATEMENT: UPDATE foobar SET f3[2] = 'b99' WHERE f1 = 11 2024-11-30 22:45:52.317 UTC client backend[19149] pg_regress/dblink ERROR: could not establish connection 2024-11-30 22:45:52.317 UTC client backend[19149] pg_regress/dblink DETAIL: missing "=" after "myconn" in connection info string 2024-11-30 22:45:52.317 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink('myconn','SELECT * FROM foo') AS t(a int, b text, c text[]) WHERE t.a > 7; 2024-11-30 22:45:52.321 UTC client backend[19156] pg_regress ERROR: relation "foobar" does not exist at character 15 2024-11-30 22:45:52.321 UTC client backend[19156] pg_regress STATEMENT: SELECT * FROM foobar 2024-11-30 22:45:52.323 UTC client backend[19149] pg_regress/dblink ERROR: duplicate connection name 2024-11-30 22:45:52.323 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_connect('myconn',connection_parameters()); 2024-11-30 22:45:52.326 UTC client backend[19156] pg_regress ERROR: relation "foobar" does not exist at character 49 2024-11-30 22:45:52.326 UTC client backend[19156] pg_regress STATEMENT: DECLARE rmt_foo_cursor CURSOR FOR SELECT * FROM foobar 2024-11-30 22:45:52.330 UTC client backend[19156] pg_regress ERROR: DECLARE CURSOR can only be used in transaction blocks 2024-11-30 22:45:52.330 UTC client backend[19156] pg_regress STATEMENT: DECLARE xact_test CURSOR FOR SELECT * FROM foo 2024-11-30 22:45:52.330 UTC client backend[19149] pg_regress/dblink ERROR: DECLARE CURSOR can only be used in transaction blocks 2024-11-30 22:45:52.330 UTC client backend[19149] pg_regress/dblink CONTEXT: while executing command on dblink connection named "myconn" 2024-11-30 22:45:52.330 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo'); 2024-11-30 22:45:52.330 UTC client backend[19156] pg_regress WARNING: there is no transaction in progress WARNING: there is no transaction in progress 2024-11-30 22:45:52.332 UTC client backend[19156] pg_regress ERROR: cursor "rmt_foobar_cursor" does not exist 2024-11-30 22:45:52.332 UTC client backend[19156] pg_regress STATEMENT: FETCH 4 FROM rmt_foobar_cursor 2024-11-30 22:45:52.333 UTC client backend[19156] pg_regress ERROR: cursor "rmt_foo_cursor" does not exist 2024-11-30 22:45:52.333 UTC client backend[19156] pg_regress STATEMENT: FETCH 4 FROM rmt_foo_cursor 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink ERROR: cursor "rmt_foo_cursor" does not exist 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink CONTEXT: while fetching from cursor "rmt_foo_cursor" on dblink connection named "myconn" 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink_fetch('myconn','rmt_foo_cursor',4) AS t(a int, b text, c text[]); 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink ERROR: could not establish connection 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink DETAIL: missing "=" after "myconn" in connection info string 2024-11-30 22:45:52.333 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT * FROM dblink('myconn','SELECT * FROM foo') AS t(a int, b text, c text[]) WHERE t.a > 7; 2024-11-30 22:45:52.339 UTC client backend[19149] pg_regress/dblink ERROR: connection "myconn" not available 2024-11-30 22:45:52.339 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_disconnect('myconn'); 2024-11-30 22:45:52.354 UTC client backend[19163] pg_regress ERROR: canceling statement due to user request 2024-11-30 22:45:52.354 UTC client backend[19163] pg_regress STATEMENT: select * from foo where f1 < 3 2024-11-30 22:45:52.355 UTC client backend[19149] pg_regress/dblink ERROR: invalid option "server" 2024-11-30 22:45:52.355 UTC client backend[19149] pg_regress/dblink STATEMENT: CREATE USER MAPPING FOR public SERVER fdtest OPTIONS (server 'localhost'); 2024-11-30 22:45:52.357 UTC client backend[19149] pg_regress/dblink ERROR: password or GSSAPI delegated credentials required 2024-11-30 22:45:52.357 UTC client backend[19149] pg_regress/dblink DETAIL: Non-superusers must provide a password in the connection string or send delegated GSSAPI credentials. 2024-11-30 22:45:52.357 UTC client backend[19149] pg_regress/dblink STATEMENT: SELECT dblink_connect('myconn', 'fdtest'); 2024-11-30 22:45:52.364 UTC client backend[19166] pg_regress/dblink ERROR: invalid option "nonexistent" 2024-11-30 22:45:52.364 UTC client backend[19166] pg_regress/dblink HINT: There are no valid options in this context. 2024-11-30 22:45:52.364 UTC client backend[19166] pg_regress/dblink STATEMENT: ALTER FOREIGN DATA WRAPPER dblink_fdw OPTIONS (nonexistent 'fdw'); 2024-11-30 22:45:52.395 UTC client backend[19166] pg_regress/dblink ERROR: invalid input syntax for type integer: "not an int" 2024-11-30 22:45:52.395 UTC client backend[19166] pg_regress/dblink STATEMENT: SELECT * FROM dblink_fetch('myconn','error_cursor', 1) AS t(i int); 2024-11-30 22:45:52.399 UTC postmaster[19138] LOG: received fast shutdown request 2024-11-30 22:45:52.399 UTC postmaster[19138] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 19138 0xaa1ce2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89e3d7 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89c8d9 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89bcb0 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres