diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out	2025-05-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out	2025-05-15 23:57:56.123399266 +0000
@@ -39,314 +39,21 @@
 \qecho '\\.'
 \qecho line2
 \o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test  
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
-copy copytest2(test) from stdin;
-ERROR:  end-of-copy marker is not alone on its line
-CONTEXT:  COPY copytest2, line 3
-copy copytest2(test) from stdin;
-ERROR:  end-of-copy marker is not alone on its line
-CONTEXT:  COPY copytest2, line 3
-select test from copytest2;
- test 
-------
-(0 rows)
-
--- test header line feature
-create temp table copytest3 (
-	c1 int,
-	"col with , comma" text,
-	"col with "" quote"  int);
-copy copytest3 from stdin csv header;
-copy copytest3 to stdout csv header;
-c1,"col with , comma","col with "" quote"
-1,a,1
-2,b,2
-create temp table copytest4 (
-	c1 int,
-	"colname with tab: 	" text);
-copy copytest4 from stdin (header);
-copy copytest4 to stdout (header);
-c1	colname with tab: \t
-1	a
-2	b
--- test copy from with a partitioned table
-create table parted_copytest (
-	a int,
-	b int,
-	c text
-) partition by list (b);
-create table parted_copytest_a1 (c text, b int, a int);
-create table parted_copytest_a2 (a int, c text, b int);
-alter table parted_copytest attach partition parted_copytest_a1 for values in(1);
-alter table parted_copytest attach partition parted_copytest_a2 for values in(2);
--- We must insert enough rows to trigger multi-inserts.  These are only
--- enabled adaptively when there are few enough partition changes.
-insert into parted_copytest select x,1,'One' from generate_series(1,1000) x;
-insert into parted_copytest select x,2,'Two' from generate_series(1001,1010) x;
-insert into parted_copytest select x,1,'One' from generate_series(1011,1020) x;
-\set filename :abs_builddir '/results/parted_copytest.csv'
-copy (select * from parted_copytest order by a) to :'filename';
-truncate parted_copytest;
-copy parted_copytest from :'filename';
--- Ensure COPY FREEZE errors for partitioned tables.
-begin;
-truncate parted_copytest;
-copy parted_copytest from :'filename' (freeze);
-ERROR:  cannot perform COPY FREEZE on a partitioned table
-rollback;
-select tableoid::regclass,count(*),sum(a) from parted_copytest
-group by tableoid order by tableoid::regclass::name;
-      tableoid      | count |  sum   
---------------------+-------+--------
- parted_copytest_a1 |  1010 | 510655
- parted_copytest_a2 |    10 |  10055
-(2 rows)
-
-truncate parted_copytest;
--- create before insert row trigger on parted_copytest_a2
-create function part_ins_func() returns trigger language plpgsql as $$
-begin
-  return new;
-end;
-$$;
-create trigger part_ins_trig
-	before insert on parted_copytest_a2
-	for each row
-	execute procedure part_ins_func();
-copy parted_copytest from :'filename';
-select tableoid::regclass,count(*),sum(a) from parted_copytest
-group by tableoid order by tableoid::regclass::name;
-      tableoid      | count |  sum   
---------------------+-------+--------
- parted_copytest_a1 |  1010 | 510655
- parted_copytest_a2 |    10 |  10055
-(2 rows)
-
-truncate table parted_copytest;
-create index on parted_copytest (b);
-drop trigger part_ins_trig on parted_copytest_a2;
-copy parted_copytest from stdin;
--- Ensure index entries were properly added during the copy.
-select * from parted_copytest where b = 1;
- a | b |  c   
----+---+------
- 1 | 1 | str1
-(1 row)
-
-select * from parted_copytest where b = 2;
- a | b |  c   
----+---+------
- 2 | 2 | str2
-(1 row)
-
-drop table parted_copytest;
---
--- Progress reporting for COPY
---
-create table tab_progress_reporting (
-	name text,
-	age int4,
-	location point,
-	salary int4,
-	manager name
-);
--- Add a trigger to catch and print the contents of the catalog view
--- pg_stat_progress_copy during data insertion.  This allows to test
--- the validation of some progress reports for COPY FROM where the trigger
--- would fire.
-create function notice_after_tab_progress_reporting() returns trigger AS
-$$
-declare report record;
-begin
-  -- The fields ignored here are the ones that may not remain
-  -- consistent across multiple runs.  The sizes reported may differ
-  -- across platforms, so just check if these are strictly positive.
-  with progress_data as (
-    select
-       relid::regclass::text as relname,
-       command,
-       type,
-       bytes_processed > 0 as has_bytes_processed,
-       bytes_total > 0 as has_bytes_total,
-       tuples_processed,
-       tuples_excluded,
-       tuples_skipped
-      from pg_stat_progress_copy
-      where pid = pg_backend_pid())
-  select into report (to_jsonb(r)) as value
-    from progress_data r;
-
-  raise info 'progress: %', report.value::text;
-  return new;
-end;
-$$ language plpgsql;
-create trigger check_after_tab_progress_reporting
-	after insert on tab_progress_reporting
-	for each statement
-	execute function notice_after_tab_progress_reporting();
--- Generate COPY FROM report with PIPE.
-copy tab_progress_reporting from stdin;
-INFO:  progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 0, "has_bytes_total": false, "tuples_excluded": 0, "tuples_processed": 3, "has_bytes_processed": true}
--- Generate COPY FROM report with FILE, with some excluded tuples.
-truncate tab_progress_reporting;
-\set filename :abs_srcdir '/data/emp.data'
-copy tab_progress_reporting from :'filename'
-	where (salary < 2000);
-INFO:  progress: {"type": "FILE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 0, "has_bytes_total": true, "tuples_excluded": 1, "tuples_processed": 2, "has_bytes_processed": true}
--- Generate COPY FROM report with PIPE, with some skipped tuples.
-copy tab_progress_reporting from stdin(on_error ignore);
-NOTICE:  2 rows were skipped due to data type incompatibility
-INFO:  progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 2, "has_bytes_total": false, "tuples_excluded": 0, "tuples_processed": 1, "has_bytes_processed": true}
-drop trigger check_after_tab_progress_reporting on tab_progress_reporting;
-drop function notice_after_tab_progress_reporting();
-drop table tab_progress_reporting;
--- Test header matching feature
-create table header_copytest (
-	a int,
-	b int,
-	c text
-);
--- Make sure it works with dropped columns
-alter table header_copytest drop column c;
-alter table header_copytest add column c text;
-copy header_copytest to stdout with (header match);
-ERROR:  cannot use "match" with HEADER in COPY TO
-copy header_copytest from stdin with (header wrong_choice);
-ERROR:  header requires a Boolean value or "match"
--- works
-copy header_copytest from stdin with (header match);
-copy header_copytest (c, a, b) from stdin with (header match);
-copy header_copytest from stdin with (header match, format csv);
--- errors
-copy header_copytest (c, b, a) from stdin with (header match);
-ERROR:  column name mismatch in header line field 1: got "a", expected "c"
-CONTEXT:  COPY header_copytest, line 1: "a	b	c"
-copy header_copytest from stdin with (header match);
-ERROR:  column name mismatch in header line field 3: got null value ("\N"), expected "c"
-CONTEXT:  COPY header_copytest, line 1: "a	b	\N"
-copy header_copytest from stdin with (header match);
-ERROR:  wrong number of fields in header line: got 2, expected 3
-CONTEXT:  COPY header_copytest, line 1: "a	b"
-copy header_copytest from stdin with (header match);
-ERROR:  wrong number of fields in header line: got 4, expected 3
-CONTEXT:  COPY header_copytest, line 1: "a	b	c	d"
-copy header_copytest from stdin with (header match);
-ERROR:  column name mismatch in header line field 3: got "d", expected "c"
-CONTEXT:  COPY header_copytest, line 1: "a	b	d"
-SELECT * FROM header_copytest ORDER BY a;
- a | b |  c  
----+---+-----
- 1 | 2 | foo
- 3 | 4 | bar
- 5 | 6 | baz
-(3 rows)
-
--- Drop an extra column, in the middle of the existing set.
-alter table header_copytest drop column b;
--- works
-copy header_copytest (c, a) from stdin with (header match);
-copy header_copytest (a, c) from stdin with (header match);
--- errors
-copy header_copytest from stdin with (header match);
-ERROR:  wrong number of fields in header line: got 3, expected 2
-CONTEXT:  COPY header_copytest, line 1: "a	........pg.dropped.2........	c"
-copy header_copytest (a, c) from stdin with (header match);
-ERROR:  wrong number of fields in header line: got 3, expected 2
-CONTEXT:  COPY header_copytest, line 1: "a	c	b"
-SELECT * FROM header_copytest ORDER BY a;
- a |  c  
----+-----
- 1 | foo
- 3 | bar
- 5 | baz
- 7 | foo
- 8 | foo
-(5 rows)
-
-drop table header_copytest;
--- test COPY with overlong column defaults
-create temp table oversized_column_default (
-    col1 varchar(5) DEFAULT 'more than 5 chars',
-    col2 varchar(5));
--- normal COPY should work
-copy oversized_column_default from stdin;
--- error if the column is excluded
-copy oversized_column_default (col2) from stdin;
-ERROR:  value too long for type character varying(5)
-\.
-invalid command \.
--- error if the DEFAULT option is given
-copy oversized_column_default from stdin (default '');
-ERROR:  value too long for type character varying(5)
-\.
-invalid command \.
-drop table oversized_column_default;
---
--- Create partitioned table that does not allow bulk insertions, to test bugs
--- related to the reuse of BulkInsertState across partitions (only done when
--- not using bulk insert).  Switching between partitions often makes it more
--- likely to encounter these bugs, so we just switch on roughly every insert
--- by having an even/odd number partition and inserting evenly distributed
--- data.
---
-CREATE TABLE parted_si (
-  id int not null,
-  data text not null,
-  -- prevent use of bulk insert by having a volatile function
-  rand float8 not null default random()
-)
-PARTITION BY LIST((id % 2));
-CREATE TABLE parted_si_p_even PARTITION OF parted_si FOR VALUES IN (0);
-CREATE TABLE parted_si_p_odd PARTITION OF parted_si FOR VALUES IN (1);
--- Test that bulk relation extension handles reusing a single BulkInsertState
--- across partitions.  Without the fix applied, this reliably reproduces
--- #18130 unless shared_buffers is extremely small (preventing any use of bulk
--- relation extension). See
--- https://postgr.es/m/18130-7a86a7356a75209d%40postgresql.org
--- https://postgr.es/m/257696.1695670946%40sss.pgh.pa.us
-\set filename :abs_srcdir '/data/desc.data'
-COPY parted_si(id, data) FROM :'filename';
--- An earlier bug (see commit b1ecb9b3fcf) could end up using a buffer from
--- the wrong partition. This test is *not* guaranteed to trigger that bug, but
--- does so when shared_buffers is small enough.  To test if we encountered the
--- bug, check that the partition condition isn't violated.
-SELECT tableoid::regclass, id % 2 = 0 is_even, count(*) from parted_si GROUP BY 1, 2 ORDER BY 1;
-     tableoid     | is_even | count 
-------------------+---------+-------
- parted_si_p_even | t       |  5000
- parted_si_p_odd  | f       |  5000
-(2 rows)
-
-DROP TABLE parted_si;
--- ensure COPY FREEZE errors for foreign tables
-begin;
-create foreign data wrapper copytest_wrapper;
-create server copytest_server foreign data wrapper copytest_wrapper;
-create foreign table copytest_foreign_table (a int) server copytest_server;
-copy copytest_foreign_table from stdin (freeze);
-ERROR:  cannot perform COPY FREEZE on a foreign table
-rollback;
--- Tests for COPY TO with materialized views.
--- COPY TO should fail for an unpopulated materialized view
--- but succeed for a populated one.
-CREATE MATERIALIZED VIEW copytest_mv AS SELECT 1 AS id WITH NO DATA;
-COPY copytest_mv(id) TO stdout WITH (header);
-ERROR:  cannot copy from unpopulated materialized view "copytest_mv"
-HINT:  Use the REFRESH MATERIALIZED VIEW command.
-REFRESH MATERIALIZED VIEW copytest_mv;
-COPY copytest_mv(id) TO stdout WITH (header);
-id
-1
-DROP MATERIALIZED VIEW copytest_mv;
+AddressSanitizer:DEADLYSIGNAL
+=================================================================
+==32862==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x55af8e1e1e67 bp 0x0fffc01bf722 sp 0x7ffe00dfb900 T0)
+==32862==The signal is caused by a READ memory access.
+==32862==Hint: address points to the zero page.
+    #0 0x55af8e1e1e67 in exec_command_out /tmp/cirrus-ci-build/src/bin/psql/command.c:2497
+    #1 0x55af8e1eb6e6 in exec_command /tmp/cirrus-ci-build/src/bin/psql/command.c:406
+    #2 0x55af8e1ebbd9 in HandleSlashCmds /tmp/cirrus-ci-build/src/bin/psql/command.c:242
+    #3 0x55af8e217248 in MainLoop /tmp/cirrus-ci-build/src/bin/psql/mainloop.c:496
+    #4 0x55af8e1e8713 in process_file /tmp/cirrus-ci-build/src/bin/psql/command.c:4925
+    #5 0x55af8e2336b7 in main /tmp/cirrus-ci-build/src/bin/psql/startup.c:420
+    #6 0x7fd511089249  (/lib/x86_64-linux-gnu/libc.so.6+0x27249)
+    #7 0x7fd511089304 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x27304)
+    #8 0x55af8e1db010 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/psql+0xb9010)
+
+AddressSanitizer can not provide additional info.
+SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/bin/psql/command.c:2497 in exec_command_out
+==32862==ABORTING
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copyselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copyselect.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/copyselect.out	2025-05-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copyselect.out	2025-05-15 23:57:56.131399304 +0000
@@ -98,22 +98,14 @@
 -- Test psql builtins, plain table
 --
 \copy test1 to stdout
-1	a
-2	b
-3	c
-4	d
-5	e
 --
 -- This should fail
 --
 \copy v_test1 to stdout
-ERROR:  cannot copy from view "v_test1"
-HINT:  Try the COPY (SELECT ...) TO variant.
 --
 -- Test \copy (select ...)
 --
 \copy (select "id",'id','id""'||t,(id + 1)*id,t,"test1"."t" from test1 where id=3) to stdout
-3	id	id""c	12	c	c
 --
 -- Drop everything
 --
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copydml.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copydml.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/copydml.out	2025-05-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copydml.out	2025-05-15 23:57:56.183399551 +0000
@@ -20,11 +20,8 @@
 -- Test \copy (insert/update/delete ...)
 --
 \copy (insert into copydml_test (t) values ('f') returning id) to stdout;
-7
 \copy (update copydml_test set t = 'g' where t = 'f' returning id) to stdout;
-7
 \copy (delete from copydml_test where t = 'g' returning id) to stdout;
-7
 -- Error cases
 copy (insert into copydml_test default values) to stdout;
 ERROR:  COPY query must have a RETURNING clause
@@ -101,16 +98,16 @@
 create trigger qqqaf after insert or update or delete on copydml_test
     for each row execute procedure qqq_trig();
 copy (insert into copydml_test (t) values ('f') returning id) to stdout;
-NOTICE:  BEFORE INSERT 8
-8
-NOTICE:  AFTER INSERT 8
+NOTICE:  BEFORE INSERT 7
+7
+NOTICE:  AFTER INSERT 7
 copy (update copydml_test set t = 'g' where t = 'f' returning id) to stdout;
-NOTICE:  BEFORE UPDATE 8
-8
-NOTICE:  AFTER UPDATE 8
+NOTICE:  BEFORE UPDATE 7
+7
+NOTICE:  AFTER UPDATE 7
 copy (delete from copydml_test where t = 'g' returning id) to stdout;
-NOTICE:  BEFORE DELETE 8
-8
-NOTICE:  AFTER DELETE 8
+NOTICE:  BEFORE DELETE 7
+7
+NOTICE:  AFTER DELETE 7
 drop table copydml_test;
 drop function qqq_trig();
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/psql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/psql.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/psql.out	2025-05-15 23:52:00.158307433 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/psql.out	2025-05-15 23:59:04.219780584 +0000
@@ -5800,1134 +5800,21 @@
 UPDATE onek SET unique1 = unique1 WHERE false;
 \set QUIET true
 \o
--- Check the contents of the files generated.
-COPY reload_output(line) FROM :'g_out_file';
-SELECT line FROM reload_output ORDER BY lineno;
- line 
-------
- 0
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
-(10 rows)
-
-TRUNCATE TABLE reload_output;
-COPY reload_output(line) FROM :'o_out_file';
-SELECT line FROM reload_output ORDER BY lineno;
-   line   
-----------
-  max 
- -----
-  999
- (1 row)
- 
-  a 
- ---
-  1
- (1 row)
- 
-  b 
- ---
-  2
- (1 row)
- 
-  c 
- ---
-  3
- (1 row)
- 
- COPY 10
- UPDATE 0
-(22 rows)
-
-TRUNCATE TABLE reload_output;
--- Multiple COPY TO STDOUT with output file
-\o :o_out_file
--- The data goes to :o_out_file with no status generated.
-COPY (SELECT 'foo1') TO STDOUT \; COPY (SELECT 'bar1') TO STDOUT;
--- Combination of \o and \g file with multiple COPY queries.
-COPY (SELECT 'foo2') TO STDOUT \; COPY (SELECT 'bar2') TO STDOUT \g :g_out_file
-\o
--- Check the contents of the files generated.
-COPY reload_output(line) FROM :'g_out_file';
-SELECT line FROM reload_output ORDER BY lineno;
- line 
-------
- foo2
- bar2
-(2 rows)
-
-TRUNCATE TABLE reload_output;
-COPY reload_output(line) FROM :'o_out_file';
-SELECT line FROM reload_output ORDER BY lineno;
- line 
-------
- foo1
- bar1
-(2 rows)
-
-DROP TABLE reload_output;
---
--- AUTOCOMMIT and combined queries
---
-\set AUTOCOMMIT off
-\echo '# AUTOCOMMIT:' :AUTOCOMMIT
-# AUTOCOMMIT: off
--- BEGIN is now implicit
-CREATE TABLE foo(s TEXT) \;
-ROLLBACK;
-CREATE TABLE foo(s TEXT) \;
-INSERT INTO foo(s) VALUES ('hello'), ('world') \;
-COMMIT;
-DROP TABLE foo \;
-ROLLBACK;
--- table foo is still there
-SELECT * FROM foo ORDER BY 1 \;
-DROP TABLE foo \;
-COMMIT;
-   s   
--------
- hello
- world
-(2 rows)
-
-\set AUTOCOMMIT on
-\echo '# AUTOCOMMIT:' :AUTOCOMMIT
-# AUTOCOMMIT: on
--- BEGIN now explicit for multi-statement transactions
-BEGIN \;
-CREATE TABLE foo(s TEXT) \;
-INSERT INTO foo(s) VALUES ('hello'), ('world') \;
-COMMIT;
-BEGIN \;
-DROP TABLE foo \;
-ROLLBACK \;
--- implicit transactions
-SELECT * FROM foo ORDER BY 1 \;
-DROP TABLE foo;
-   s   
--------
- hello
- world
-(2 rows)
-
---
--- test ON_ERROR_ROLLBACK and combined queries
---
-CREATE FUNCTION psql_error(msg TEXT) RETURNS BOOLEAN AS $$
-  BEGIN
-    RAISE EXCEPTION 'error %', msg;
-  END;
-$$ LANGUAGE plpgsql;
-\set ON_ERROR_ROLLBACK on
-\echo '# ON_ERROR_ROLLBACK:' :ON_ERROR_ROLLBACK
-# ON_ERROR_ROLLBACK: on
-\echo '# AUTOCOMMIT:' :AUTOCOMMIT
-# AUTOCOMMIT: on
-BEGIN;
-CREATE TABLE bla(s NO_SUCH_TYPE);               -- fails
-ERROR:  type "no_such_type" does not exist
-LINE 1: CREATE TABLE bla(s NO_SUCH_TYPE);
-                           ^
-CREATE TABLE bla(s TEXT);                       -- succeeds
-SELECT psql_error('oops!');                     -- fails
-ERROR:  error oops!
-CONTEXT:  PL/pgSQL function psql_error(text) line 3 at RAISE
-INSERT INTO bla VALUES ('Calvin'), ('Hobbes');
-COMMIT;
-SELECT * FROM bla ORDER BY 1;
-   s    
---------
- Calvin
- Hobbes
-(2 rows)
-
-BEGIN;
-INSERT INTO bla VALUES ('Susie');         -- succeeds
--- now with combined queries
-INSERT INTO bla VALUES ('Rosalyn') \;     -- will rollback
-SELECT 'before error' AS show \;          -- will show nevertheless!
-  SELECT psql_error('boum!') \;           -- failure
-  SELECT 'after error' AS noshow;         -- hidden by preceding error
-     show     
---------------
- before error
-(1 row)
-
-ERROR:  error boum!
-CONTEXT:  PL/pgSQL function psql_error(text) line 3 at RAISE
-INSERT INTO bla(s) VALUES ('Moe') \;      -- will rollback
-  SELECT psql_error('bam!');
-ERROR:  error bam!
-CONTEXT:  PL/pgSQL function psql_error(text) line 3 at RAISE
-INSERT INTO bla VALUES ('Miss Wormwood'); -- succeeds
-COMMIT;
-SELECT * FROM bla ORDER BY 1;
-       s       
----------------
- Calvin
- Hobbes
- Miss Wormwood
- Susie
-(4 rows)
-
--- some with autocommit off
-\set AUTOCOMMIT off
-\echo '# AUTOCOMMIT:' :AUTOCOMMIT
-# AUTOCOMMIT: off
--- implicit BEGIN
-INSERT INTO bla VALUES ('Dad');           -- succeeds
-SELECT psql_error('bad!');                -- implicit partial rollback
-ERROR:  error bad!
-CONTEXT:  PL/pgSQL function psql_error(text) line 3 at RAISE
-INSERT INTO bla VALUES ('Mum') \;         -- will rollback
-SELECT COUNT(*) AS "#mum"
-FROM bla WHERE s = 'Mum' \;               -- but be counted here
-SELECT psql_error('bad!');                -- implicit partial rollback
- #mum 
-------
-    1
-(1 row)
-
-ERROR:  error bad!
-CONTEXT:  PL/pgSQL function psql_error(text) line 3 at RAISE
-COMMIT;
-SELECT COUNT(*) AS "#mum"
-FROM bla WHERE s = 'Mum' \;               -- no mum here
-SELECT * FROM bla ORDER BY 1;
- #mum 
-------
-    0
-(1 row)
-
-       s       
----------------
- Calvin
- Dad
- Hobbes
- Miss Wormwood
- Susie
-(5 rows)
-
-COMMIT;
--- reset all
-\set AUTOCOMMIT on
-\set ON_ERROR_ROLLBACK off
-\echo '# final ON_ERROR_ROLLBACK:' :ON_ERROR_ROLLBACK
-# final ON_ERROR_ROLLBACK: off
-DROP TABLE bla;
-DROP FUNCTION psql_error;
--- check describing invalid multipart names
-\dA regression.heap
-improper qualified name (too many dotted names): regression.heap
-\dA nonesuch.heap
-improper qualified name (too many dotted names): nonesuch.heap
-\dt host.regression.pg_catalog.pg_class
-improper qualified name (too many dotted names): host.regression.pg_catalog.pg_class
-\dt |.pg_catalog.pg_class
-cross-database references are not implemented: |.pg_catalog.pg_class
-\dt nonesuch.pg_catalog.pg_class
-cross-database references are not implemented: nonesuch.pg_catalog.pg_class
-\da host.regression.pg_catalog.sum
-improper qualified name (too many dotted names): host.regression.pg_catalog.sum
-\da +.pg_catalog.sum
-cross-database references are not implemented: +.pg_catalog.sum
-\da nonesuch.pg_catalog.sum
-cross-database references are not implemented: nonesuch.pg_catalog.sum
-\dAc nonesuch.brin
-improper qualified name (too many dotted names): nonesuch.brin
-\dAc regression.brin
-improper qualified name (too many dotted names): regression.brin
-\dAf nonesuch.brin
-improper qualified name (too many dotted names): nonesuch.brin
-\dAf regression.brin
-improper qualified name (too many dotted names): regression.brin
-\dAo nonesuch.brin
-improper qualified name (too many dotted names): nonesuch.brin
-\dAo regression.brin
-improper qualified name (too many dotted names): regression.brin
-\dAp nonesuch.brin
-improper qualified name (too many dotted names): nonesuch.brin
-\dAp regression.brin
-improper qualified name (too many dotted names): regression.brin
-\db nonesuch.pg_default
-improper qualified name (too many dotted names): nonesuch.pg_default
-\db regression.pg_default
-improper qualified name (too many dotted names): regression.pg_default
-\dc host.regression.public.conversion
-improper qualified name (too many dotted names): host.regression.public.conversion
-\dc (.public.conversion
-cross-database references are not implemented: (.public.conversion
-\dc nonesuch.public.conversion
-cross-database references are not implemented: nonesuch.public.conversion
-\dC host.regression.pg_catalog.int8
-improper qualified name (too many dotted names): host.regression.pg_catalog.int8
-\dC ).pg_catalog.int8
-cross-database references are not implemented: ).pg_catalog.int8
-\dC nonesuch.pg_catalog.int8
-cross-database references are not implemented: nonesuch.pg_catalog.int8
-\dd host.regression.pg_catalog.pg_class
-improper qualified name (too many dotted names): host.regression.pg_catalog.pg_class
-\dd [.pg_catalog.pg_class
-cross-database references are not implemented: [.pg_catalog.pg_class
-\dd nonesuch.pg_catalog.pg_class
-cross-database references are not implemented: nonesuch.pg_catalog.pg_class
-\dD host.regression.public.gtestdomain1
-improper qualified name (too many dotted names): host.regression.public.gtestdomain1
-\dD ].public.gtestdomain1
-cross-database references are not implemented: ].public.gtestdomain1
-\dD nonesuch.public.gtestdomain1
-cross-database references are not implemented: nonesuch.public.gtestdomain1
-\ddp host.regression.pg_catalog.pg_class
-improper qualified name (too many dotted names): host.regression.pg_catalog.pg_class
-\ddp {.pg_catalog.pg_class
-cross-database references are not implemented: {.pg_catalog.pg_class
-\ddp nonesuch.pg_catalog.pg_class
-cross-database references are not implemented: nonesuch.pg_catalog.pg_class
-\dE host.regression.public.ft
-improper qualified name (too many dotted names): host.regression.public.ft
-\dE }.public.ft
-cross-database references are not implemented: }.public.ft
-\dE nonesuch.public.ft
-cross-database references are not implemented: nonesuch.public.ft
-\di host.regression.public.tenk1_hundred
-improper qualified name (too many dotted names): host.regression.public.tenk1_hundred
-\di ..public.tenk1_hundred
-improper qualified name (too many dotted names): ..public.tenk1_hundred
-\di nonesuch.public.tenk1_hundred
-cross-database references are not implemented: nonesuch.public.tenk1_hundred
-\dm host.regression.public.mvtest_bb
-improper qualified name (too many dotted names): host.regression.public.mvtest_bb
-\dm ^.public.mvtest_bb
-cross-database references are not implemented: ^.public.mvtest_bb
-\dm nonesuch.public.mvtest_bb
-cross-database references are not implemented: nonesuch.public.mvtest_bb
-\ds host.regression.public.check_seq
-improper qualified name (too many dotted names): host.regression.public.check_seq
-\ds regression|mydb.public.check_seq
-cross-database references are not implemented: regression|mydb.public.check_seq
-\ds nonesuch.public.check_seq
-cross-database references are not implemented: nonesuch.public.check_seq
-\dt host.regression.public.b_star
-improper qualified name (too many dotted names): host.regression.public.b_star
-\dt regres+ion.public.b_star
-cross-database references are not implemented: regres+ion.public.b_star
-\dt nonesuch.public.b_star
-cross-database references are not implemented: nonesuch.public.b_star
-\dv host.regression.public.shoe
-improper qualified name (too many dotted names): host.regression.public.shoe
-\dv regress(ion).public.shoe
-cross-database references are not implemented: regress(ion).public.shoe
-\dv nonesuch.public.shoe
-cross-database references are not implemented: nonesuch.public.shoe
-\des nonesuch.server
-improper qualified name (too many dotted names): nonesuch.server
-\des regression.server
-improper qualified name (too many dotted names): regression.server
-\des nonesuch.server
-improper qualified name (too many dotted names): nonesuch.server
-\des regression.server
-improper qualified name (too many dotted names): regression.server
-\des nonesuch.username
-improper qualified name (too many dotted names): nonesuch.username
-\des regression.username
-improper qualified name (too many dotted names): regression.username
-\dew nonesuch.fdw
-improper qualified name (too many dotted names): nonesuch.fdw
-\dew regression.fdw
-improper qualified name (too many dotted names): regression.fdw
-\df host.regression.public.namelen
-improper qualified name (too many dotted names): host.regression.public.namelen
-\df regres[qrstuv]ion.public.namelen
-cross-database references are not implemented: regres[qrstuv]ion.public.namelen
-\df nonesuch.public.namelen
-cross-database references are not implemented: nonesuch.public.namelen
-\dF host.regression.pg_catalog.arabic
-improper qualified name (too many dotted names): host.regression.pg_catalog.arabic
-\dF regres{1,2}ion.pg_catalog.arabic
-cross-database references are not implemented: regres{1,2}ion.pg_catalog.arabic
-\dF nonesuch.pg_catalog.arabic
-cross-database references are not implemented: nonesuch.pg_catalog.arabic
-\dFd host.regression.pg_catalog.arabic_stem
-improper qualified name (too many dotted names): host.regression.pg_catalog.arabic_stem
-\dFd regres?ion.pg_catalog.arabic_stem
-cross-database references are not implemented: regres?ion.pg_catalog.arabic_stem
-\dFd nonesuch.pg_catalog.arabic_stem
-cross-database references are not implemented: nonesuch.pg_catalog.arabic_stem
-\dFp host.regression.pg_catalog.default
-improper qualified name (too many dotted names): host.regression.pg_catalog.default
-\dFp ^regression.pg_catalog.default
-cross-database references are not implemented: ^regression.pg_catalog.default
-\dFp nonesuch.pg_catalog.default
-cross-database references are not implemented: nonesuch.pg_catalog.default
-\dFt host.regression.pg_catalog.ispell
-improper qualified name (too many dotted names): host.regression.pg_catalog.ispell
-\dFt regression$.pg_catalog.ispell
-cross-database references are not implemented: regression$.pg_catalog.ispell
-\dFt nonesuch.pg_catalog.ispell
-cross-database references are not implemented: nonesuch.pg_catalog.ispell
-\dg nonesuch.pg_database_owner
-improper qualified name (too many dotted names): nonesuch.pg_database_owner
-\dg regression.pg_database_owner
-improper qualified name (too many dotted names): regression.pg_database_owner
-\dL host.regression.plpgsql
-improper qualified name (too many dotted names): host.regression.plpgsql
-\dL *.plpgsql
-cross-database references are not implemented: *.plpgsql
-\dL nonesuch.plpgsql
-cross-database references are not implemented: nonesuch.plpgsql
-\dn host.regression.public
-improper qualified name (too many dotted names): host.regression.public
-\dn """".public
-cross-database references are not implemented: """".public
-\dn nonesuch.public
-cross-database references are not implemented: nonesuch.public
-\do host.regression.public.!=-
-improper qualified name (too many dotted names): host.regression.public.!=-
-\do "regression|mydb".public.!=-
-cross-database references are not implemented: "regression|mydb".public.!=-
-\do nonesuch.public.!=-
-cross-database references are not implemented: nonesuch.public.!=-
-\dO host.regression.pg_catalog.POSIX
-improper qualified name (too many dotted names): host.regression.pg_catalog.POSIX
-\dO .pg_catalog.POSIX
-cross-database references are not implemented: .pg_catalog.POSIX
-\dO nonesuch.pg_catalog.POSIX
-cross-database references are not implemented: nonesuch.pg_catalog.POSIX
-\dp host.regression.public.a_star
-improper qualified name (too many dotted names): host.regression.public.a_star
-\dp "regres+ion".public.a_star
-cross-database references are not implemented: "regres+ion".public.a_star
-\dp nonesuch.public.a_star
-cross-database references are not implemented: nonesuch.public.a_star
-\dP host.regression.public.mlparted
-improper qualified name (too many dotted names): host.regression.public.mlparted
-\dP "regres(sion)".public.mlparted
-cross-database references are not implemented: "regres(sion)".public.mlparted
-\dP nonesuch.public.mlparted
-cross-database references are not implemented: nonesuch.public.mlparted
-\drds nonesuch.lc_messages
-improper qualified name (too many dotted names): nonesuch.lc_messages
-\drds regression.lc_messages
-improper qualified name (too many dotted names): regression.lc_messages
-\dRp public.mypub
-improper qualified name (too many dotted names): public.mypub
-\dRp regression.mypub
-improper qualified name (too many dotted names): regression.mypub
-\dRs public.mysub
-improper qualified name (too many dotted names): public.mysub
-\dRs regression.mysub
-improper qualified name (too many dotted names): regression.mysub
-\dT host.regression.public.widget
-improper qualified name (too many dotted names): host.regression.public.widget
-\dT "regression{1,2}".public.widget
-cross-database references are not implemented: "regression{1,2}".public.widget
-\dT nonesuch.public.widget
-cross-database references are not implemented: nonesuch.public.widget
-\dx regression.plpgsql
-improper qualified name (too many dotted names): regression.plpgsql
-\dx nonesuch.plpgsql
-improper qualified name (too many dotted names): nonesuch.plpgsql
-\dX host.regression.public.func_deps_stat
-improper qualified name (too many dotted names): host.regression.public.func_deps_stat
-\dX "^regression$".public.func_deps_stat
-cross-database references are not implemented: "^regression$".public.func_deps_stat
-\dX nonesuch.public.func_deps_stat
-cross-database references are not implemented: nonesuch.public.func_deps_stat
-\dy regression.myevt
-improper qualified name (too many dotted names): regression.myevt
-\dy nonesuch.myevt
-improper qualified name (too many dotted names): nonesuch.myevt
--- check that dots within quoted name segments are not counted
-\dA "no.such.access.method"
-List of access methods
- Name | Type 
-------+------
-(0 rows)
-
-\dt "no.such.table.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\da "no.such.aggregate.function"
-                     List of aggregate functions
- Schema | Name | Result data type | Argument data types | Description 
---------+------+------------------+---------------------+-------------
-(0 rows)
-
-\dAc "no.such.operator.class"
-                  List of operator classes
- AM | Input type | Storage type | Operator class | Default? 
-----+------------+--------------+----------------+----------
-(0 rows)
-
-\dAf "no.such.operator.family"
-        List of operator families
- AM | Operator family | Applicable types 
-----+-----------------+------------------
-(0 rows)
-
-\dAo "no.such.operator.of.operator.family"
-        List of operators of operator families
- AM | Operator family | Operator | Strategy | Purpose 
-----+-----------------+----------+----------+---------
-(0 rows)
-
-\dAp "no.such.operator.support.function.of.operator.family"
-                     List of support functions of operator families
- AM | Operator family | Registered left type | Registered right type | Number | Function 
-----+-----------------+----------------------+-----------------------+--------+----------
-(0 rows)
-
-\db "no.such.tablespace"
-   List of tablespaces
- Name | Owner | Location 
-------+-------+----------
-(0 rows)
-
-\dc "no.such.conversion"
-               List of conversions
- Schema | Name | Source | Destination | Default? 
---------+------+--------+-------------+----------
-(0 rows)
-
-\dC "no.such.cast"
-                  List of casts
- Source type | Target type | Function | Implicit? 
--------------+-------------+----------+-----------
-(0 rows)
-
-\dd "no.such.object.description"
-         Object descriptions
- Schema | Name | Object | Description 
---------+------+--------+-------------
-(0 rows)
-
-\dD "no.such.domain"
-                        List of domains
- Schema | Name | Type | Collation | Nullable | Default | Check 
---------+------+------+-----------+----------+---------+-------
-(0 rows)
-
-\ddp "no.such.default.access.privilege"
-         Default access privileges
- Owner | Schema | Type | Access privileges 
--------+--------+------+-------------------
-(0 rows)
-
-\di "no.such.index.relation"
-           List of indexes
- Schema | Name | Type | Owner | Table 
---------+------+------+-------+-------
-(0 rows)
-
-\dm "no.such.materialized.view"
-  List of materialized views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\ds "no.such.relation"
-      List of sequences
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dt "no.such.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dv "no.such.relation"
-        List of views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\des "no.such.foreign.server"
-       List of foreign servers
- Name | Owner | Foreign-data wrapper 
-------+-------+----------------------
-(0 rows)
-
-\dew "no.such.foreign.data.wrapper"
-   List of foreign-data wrappers
- Name | Owner | Handler | Validator 
-------+-------+---------+-----------
-(0 rows)
-
-\df "no.such.function"
-                       List of functions
- Schema | Name | Result data type | Argument data types | Type 
---------+------+------------------+---------------------+------
-(0 rows)
-
-\dF "no.such.text.search.configuration"
-List of text search configurations
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFd "no.such.text.search.dictionary"
-List of text search dictionaries
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFp "no.such.text.search.parser"
- List of text search parsers
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFt "no.such.text.search.template"
-List of text search templates
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dg "no.such.role"
-     List of roles
- Role name | Attributes 
------------+------------
-
-\dL "no.such.language"
-          List of languages
- Name | Owner | Trusted | Description 
-------+-------+---------+-------------
-(0 rows)
-
-\dn "no.such.schema"
-List of schemas
- Name | Owner 
-------+-------
-(0 rows)
-
-\do "no.such.operator"
-                             List of operators
- Schema | Name | Left arg type | Right arg type | Result type | Description 
---------+------+---------------+----------------+-------------+-------------
-(0 rows)
-
-\dO "no.such.collation"
-                                List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic? 
---------+------+----------+---------+-------+--------+-----------+----------------
-(0 rows)
-
-\dp "no.such.access.privilege"
-                            Access privileges
- Schema | Name | Type | Access privileges | Column privileges | Policies 
---------+------+------+-------------------+-------------------+----------
-(0 rows)
-
-\dP "no.such.partitioned.relation"
-           List of partitioned relations
- Schema | Name | Owner | Type | Parent name | Table 
---------+------+-------+------+-------------+-------
-(0 rows)
-
-\drds "no.such.setting"
-      List of settings
- Role | Database | Settings 
-------+----------+----------
-(0 rows)
-
-\dRp "no.such.publication"
-                                        List of publications
- Name | Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root 
-------+-------+------------+---------+---------+---------+-----------+-------------------+----------
-(0 rows)
-
-\dRs "no.such.subscription"
-        List of subscriptions
- Name | Owner | Enabled | Publication 
-------+-------+---------+-------------
-(0 rows)
-
-\dT "no.such.data.type"
-     List of data types
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dx "no.such.installed.extension"
-              List of installed extensions
- Name | Version | Default version | Schema | Description 
-------+---------+-----------------+--------+-------------
-(0 rows)
-
-\dX "no.such.extended.statistics"
-                 List of extended statistics
- Schema | Name | Definition | Ndistinct | Dependencies | MCV 
---------+------+------------+-----------+--------------+-----
-(0 rows)
-
-\dy "no.such.event.trigger"
-              List of event triggers
- Name | Event | Owner | Enabled | Function | Tags 
-------+-------+-------+---------+----------+------
-(0 rows)
-
--- again, but with dotted schema qualifications.
-\dA "no.such.schema"."no.such.access.method"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.access.method"
-\dt "no.such.schema"."no.such.table.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\da "no.such.schema"."no.such.aggregate.function"
-                     List of aggregate functions
- Schema | Name | Result data type | Argument data types | Description 
---------+------+------------------+---------------------+-------------
-(0 rows)
-
-\dAc "no.such.schema"."no.such.operator.class"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.operator.class"
-\dAf "no.such.schema"."no.such.operator.family"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.operator.family"
-\dAo "no.such.schema"."no.such.operator.of.operator.family"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.operator.of.operator.family"
-\dAp "no.such.schema"."no.such.operator.support.function.of.operator.family"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.operator.support.function.of.operator.family"
-\db "no.such.schema"."no.such.tablespace"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.tablespace"
-\dc "no.such.schema"."no.such.conversion"
-               List of conversions
- Schema | Name | Source | Destination | Default? 
---------+------+--------+-------------+----------
-(0 rows)
-
-\dC "no.such.schema"."no.such.cast"
-                  List of casts
- Source type | Target type | Function | Implicit? 
--------------+-------------+----------+-----------
-(0 rows)
-
-\dd "no.such.schema"."no.such.object.description"
-         Object descriptions
- Schema | Name | Object | Description 
---------+------+--------+-------------
-(0 rows)
-
-\dD "no.such.schema"."no.such.domain"
-                        List of domains
- Schema | Name | Type | Collation | Nullable | Default | Check 
---------+------+------+-----------+----------+---------+-------
-(0 rows)
-
-\ddp "no.such.schema"."no.such.default.access.privilege"
-         Default access privileges
- Owner | Schema | Type | Access privileges 
--------+--------+------+-------------------
-(0 rows)
-
-\di "no.such.schema"."no.such.index.relation"
-           List of indexes
- Schema | Name | Type | Owner | Table 
---------+------+------+-------+-------
-(0 rows)
-
-\dm "no.such.schema"."no.such.materialized.view"
-  List of materialized views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\ds "no.such.schema"."no.such.relation"
-      List of sequences
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dt "no.such.schema"."no.such.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dv "no.such.schema"."no.such.relation"
-        List of views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\des "no.such.schema"."no.such.foreign.server"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.foreign.server"
-\dew "no.such.schema"."no.such.foreign.data.wrapper"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.foreign.data.wrapper"
-\df "no.such.schema"."no.such.function"
-                       List of functions
- Schema | Name | Result data type | Argument data types | Type 
---------+------+------------------+---------------------+------
-(0 rows)
-
-\dF "no.such.schema"."no.such.text.search.configuration"
-List of text search configurations
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFd "no.such.schema"."no.such.text.search.dictionary"
-List of text search dictionaries
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFp "no.such.schema"."no.such.text.search.parser"
- List of text search parsers
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFt "no.such.schema"."no.such.text.search.template"
-List of text search templates
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dg "no.such.schema"."no.such.role"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.role"
-\dL "no.such.schema"."no.such.language"
-cross-database references are not implemented: "no.such.schema"."no.such.language"
-\do "no.such.schema"."no.such.operator"
-                             List of operators
- Schema | Name | Left arg type | Right arg type | Result type | Description 
---------+------+---------------+----------------+-------------+-------------
-(0 rows)
-
-\dO "no.such.schema"."no.such.collation"
-                                List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic? 
---------+------+----------+---------+-------+--------+-----------+----------------
-(0 rows)
-
-\dp "no.such.schema"."no.such.access.privilege"
-                            Access privileges
- Schema | Name | Type | Access privileges | Column privileges | Policies 
---------+------+------+-------------------+-------------------+----------
-(0 rows)
-
-\dP "no.such.schema"."no.such.partitioned.relation"
-           List of partitioned relations
- Schema | Name | Owner | Type | Parent name | Table 
---------+------+-------+------+-------------+-------
-(0 rows)
-
-\drds "no.such.schema"."no.such.setting"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.setting"
-\dRp "no.such.schema"."no.such.publication"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.publication"
-\dRs "no.such.schema"."no.such.subscription"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.subscription"
-\dT "no.such.schema"."no.such.data.type"
-     List of data types
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dx "no.such.schema"."no.such.installed.extension"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.installed.extension"
-\dX "no.such.schema"."no.such.extended.statistics"
-                 List of extended statistics
- Schema | Name | Definition | Ndistinct | Dependencies | MCV 
---------+------+------------+-----------+--------------+-----
-(0 rows)
-
-\dy "no.such.schema"."no.such.event.trigger"
-improper qualified name (too many dotted names): "no.such.schema"."no.such.event.trigger"
--- again, but with current database and dotted schema qualifications.
-\dt regression."no.such.schema"."no.such.table.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\da regression."no.such.schema"."no.such.aggregate.function"
-                     List of aggregate functions
- Schema | Name | Result data type | Argument data types | Description 
---------+------+------------------+---------------------+-------------
-(0 rows)
-
-\dc regression."no.such.schema"."no.such.conversion"
-               List of conversions
- Schema | Name | Source | Destination | Default? 
---------+------+--------+-------------+----------
-(0 rows)
-
-\dC regression."no.such.schema"."no.such.cast"
-                  List of casts
- Source type | Target type | Function | Implicit? 
--------------+-------------+----------+-----------
-(0 rows)
-
-\dd regression."no.such.schema"."no.such.object.description"
-         Object descriptions
- Schema | Name | Object | Description 
---------+------+--------+-------------
-(0 rows)
-
-\dD regression."no.such.schema"."no.such.domain"
-                        List of domains
- Schema | Name | Type | Collation | Nullable | Default | Check 
---------+------+------+-----------+----------+---------+-------
-(0 rows)
-
-\di regression."no.such.schema"."no.such.index.relation"
-           List of indexes
- Schema | Name | Type | Owner | Table 
---------+------+------+-------+-------
-(0 rows)
-
-\dm regression."no.such.schema"."no.such.materialized.view"
-  List of materialized views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\ds regression."no.such.schema"."no.such.relation"
-      List of sequences
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dt regression."no.such.schema"."no.such.relation"
-        List of tables
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\dv regression."no.such.schema"."no.such.relation"
-        List of views
- Schema | Name | Type | Owner 
---------+------+------+-------
-(0 rows)
-
-\df regression."no.such.schema"."no.such.function"
-                       List of functions
- Schema | Name | Result data type | Argument data types | Type 
---------+------+------------------+---------------------+------
-(0 rows)
-
-\dF regression."no.such.schema"."no.such.text.search.configuration"
-List of text search configurations
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFd regression."no.such.schema"."no.such.text.search.dictionary"
-List of text search dictionaries
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFp regression."no.such.schema"."no.such.text.search.parser"
- List of text search parsers
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dFt regression."no.such.schema"."no.such.text.search.template"
-List of text search templates
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\do regression."no.such.schema"."no.such.operator"
-                             List of operators
- Schema | Name | Left arg type | Right arg type | Result type | Description 
---------+------+---------------+----------------+-------------+-------------
-(0 rows)
-
-\dO regression."no.such.schema"."no.such.collation"
-                                List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic? 
---------+------+----------+---------+-------+--------+-----------+----------------
-(0 rows)
-
-\dp regression."no.such.schema"."no.such.access.privilege"
-                            Access privileges
- Schema | Name | Type | Access privileges | Column privileges | Policies 
---------+------+------+-------------------+-------------------+----------
-(0 rows)
-
-\dP regression."no.such.schema"."no.such.partitioned.relation"
-           List of partitioned relations
- Schema | Name | Owner | Type | Parent name | Table 
---------+------+-------+------+-------------+-------
-(0 rows)
-
-\dT regression."no.such.schema"."no.such.data.type"
-     List of data types
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\dX regression."no.such.schema"."no.such.extended.statistics"
-                 List of extended statistics
- Schema | Name | Definition | Ndistinct | Dependencies | MCV 
---------+------+------------+-----------+--------------+-----
-(0 rows)
-
--- again, but with dotted database and dotted schema qualifications.
-\dt "no.such.database"."no.such.schema"."no.such.table.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.table.relation"
-\da "no.such.database"."no.such.schema"."no.such.aggregate.function"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.aggregate.function"
-\dc "no.such.database"."no.such.schema"."no.such.conversion"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.conversion"
-\dC "no.such.database"."no.such.schema"."no.such.cast"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.cast"
-\dd "no.such.database"."no.such.schema"."no.such.object.description"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.object.description"
-\dD "no.such.database"."no.such.schema"."no.such.domain"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.domain"
-\ddp "no.such.database"."no.such.schema"."no.such.default.access.privilege"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.default.access.privilege"
-\di "no.such.database"."no.such.schema"."no.such.index.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.index.relation"
-\dm "no.such.database"."no.such.schema"."no.such.materialized.view"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.materialized.view"
-\ds "no.such.database"."no.such.schema"."no.such.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.relation"
-\dt "no.such.database"."no.such.schema"."no.such.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.relation"
-\dv "no.such.database"."no.such.schema"."no.such.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.relation"
-\df "no.such.database"."no.such.schema"."no.such.function"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.function"
-\dF "no.such.database"."no.such.schema"."no.such.text.search.configuration"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.text.search.configuration"
-\dFd "no.such.database"."no.such.schema"."no.such.text.search.dictionary"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.text.search.dictionary"
-\dFp "no.such.database"."no.such.schema"."no.such.text.search.parser"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.text.search.parser"
-\dFt "no.such.database"."no.such.schema"."no.such.text.search.template"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.text.search.template"
-\do "no.such.database"."no.such.schema"."no.such.operator"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.operator"
-\dO "no.such.database"."no.such.schema"."no.such.collation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.collation"
-\dp "no.such.database"."no.such.schema"."no.such.access.privilege"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.access.privilege"
-\dP "no.such.database"."no.such.schema"."no.such.partitioned.relation"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.partitioned.relation"
-\dT "no.such.database"."no.such.schema"."no.such.data.type"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.data.type"
-\dX "no.such.database"."no.such.schema"."no.such.extended.statistics"
-cross-database references are not implemented: "no.such.database"."no.such.schema"."no.such.extended.statistics"
--- check \drg and \du
-CREATE ROLE regress_du_role0;
-CREATE ROLE regress_du_role1;
-CREATE ROLE regress_du_role2;
-CREATE ROLE regress_du_admin;
-GRANT regress_du_role0 TO regress_du_admin WITH ADMIN TRUE;
-GRANT regress_du_role1 TO regress_du_admin WITH ADMIN TRUE;
-GRANT regress_du_role2 TO regress_du_admin WITH ADMIN TRUE;
-GRANT regress_du_role0 TO regress_du_role1 WITH ADMIN TRUE,  INHERIT TRUE,  SET TRUE  GRANTED BY regress_du_admin;
-GRANT regress_du_role0 TO regress_du_role2 WITH ADMIN TRUE,  INHERIT FALSE, SET FALSE GRANTED BY regress_du_admin;
-GRANT regress_du_role1 TO regress_du_role2 WITH ADMIN TRUE , INHERIT FALSE, SET TRUE  GRANTED BY regress_du_admin;
-GRANT regress_du_role0 TO regress_du_role1 WITH ADMIN FALSE, INHERIT TRUE,  SET FALSE GRANTED BY regress_du_role1;
-GRANT regress_du_role0 TO regress_du_role2 WITH ADMIN FALSE, INHERIT TRUE , SET TRUE  GRANTED BY regress_du_role1;
-GRANT regress_du_role0 TO regress_du_role1 WITH ADMIN FALSE, INHERIT FALSE, SET TRUE  GRANTED BY regress_du_role2;
-GRANT regress_du_role0 TO regress_du_role2 WITH ADMIN FALSE, INHERIT FALSE, SET FALSE GRANTED BY regress_du_role2;
-\drg regress_du_role*
-                             List of role grants
-    Role name     |    Member of     |       Options       |     Grantor      
-------------------+------------------+---------------------+------------------
- regress_du_role1 | regress_du_role0 | ADMIN, INHERIT, SET | regress_du_admin
- regress_du_role1 | regress_du_role0 | INHERIT             | regress_du_role1
- regress_du_role1 | regress_du_role0 | SET                 | regress_du_role2
- regress_du_role2 | regress_du_role0 | ADMIN               | regress_du_admin
- regress_du_role2 | regress_du_role0 | INHERIT, SET        | regress_du_role1
- regress_du_role2 | regress_du_role0 |                     | regress_du_role2
- regress_du_role2 | regress_du_role1 | ADMIN, SET          | regress_du_admin
-(7 rows)
-
-\du regress_du_role*
-          List of roles
-    Role name     |  Attributes  
-------------------+--------------
- regress_du_role0 | Cannot login
- regress_du_role1 | Cannot login
- regress_du_role2 | Cannot login
-
-DROP ROLE regress_du_role0;
-DROP ROLE regress_du_role1;
-DROP ROLE regress_du_role2;
-DROP ROLE regress_du_admin;
--- Test display of empty privileges.
-BEGIN;
--- Create an owner for tested objects because output contains owner name.
-CREATE ROLE regress_zeropriv_owner;
-SET LOCAL ROLE regress_zeropriv_owner;
-CREATE DOMAIN regress_zeropriv_domain AS int;
-REVOKE ALL ON DOMAIN regress_zeropriv_domain FROM CURRENT_USER, PUBLIC;
-\dD+ regress_zeropriv_domain
-                                                    List of domains
- Schema |          Name           |  Type   | Collation | Nullable | Default | Check | Access privileges | Description 
---------+-------------------------+---------+-----------+----------+---------+-------+-------------------+-------------
- public | regress_zeropriv_domain | integer |           |          |         |       | (none)            | 
-(1 row)
-
-CREATE PROCEDURE regress_zeropriv_proc() LANGUAGE sql AS '';
-REVOKE ALL ON PROCEDURE regress_zeropriv_proc() FROM CURRENT_USER, PUBLIC;
-\df+ regress_zeropriv_proc
-                                                                                                  List of functions
- Schema |         Name          | Result data type | Argument data types | Type | Volatility | Parallel |         Owner          | Security | Leakproof? | Access privileges | Language | Internal name | Description 
---------+-----------------------+------------------+---------------------+------+------------+----------+------------------------+----------+------------+-------------------+----------+---------------+-------------
- public | regress_zeropriv_proc |                  |                     | proc | volatile   | unsafe   | regress_zeropriv_owner | invoker  | no         | (none)            | sql      |               | 
-(1 row)
-
-CREATE TABLE regress_zeropriv_tbl (a int);
-REVOKE ALL ON TABLE regress_zeropriv_tbl FROM CURRENT_USER;
-\dp regress_zeropriv_tbl
-                                    Access privileges
- Schema |         Name         | Type  | Access privileges | Column privileges | Policies 
---------+----------------------+-------+-------------------+-------------------+----------
- public | regress_zeropriv_tbl | table | (none)            |                   | 
-(1 row)
-
-CREATE TYPE regress_zeropriv_type AS (a int);
-REVOKE ALL ON TYPE regress_zeropriv_type FROM CURRENT_USER, PUBLIC;
-\dT+ regress_zeropriv_type
-                                                          List of data types
- Schema |         Name          |     Internal name     | Size  | Elements |         Owner          | Access privileges | Description 
---------+-----------------------+-----------------------+-------+----------+------------------------+-------------------+-------------
- public | regress_zeropriv_type | regress_zeropriv_type | tuple |          | regress_zeropriv_owner | (none)            | 
-(1 row)
-
-ROLLBACK;
--- Test display of default privileges with \pset null.
-CREATE TABLE defprivs (a int);
-\pset null '(default)'
-\z defprivs
-                              Access privileges
- Schema |   Name   | Type  | Access privileges | Column privileges | Policies 
---------+----------+-------+-------------------+-------------------+----------
- public | defprivs | table | (default)         |                   | 
-(1 row)
-
-\zx defprivs
-Access privileges
--[ RECORD 1 ]-----+----------
-Schema            | public
-Name              | defprivs
-Type              | table
-Access privileges | (default)
-Column privileges | 
-Policies          | 
-
-\pset null ''
-DROP TABLE defprivs;
+AddressSanitizer:DEADLYSIGNAL
+=================================================================
+==39042==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x55ef321a9e67 bp 0x0fff88ff438a sp 0x7ffc47fa1c40 T0)
+==39042==The signal is caused by a READ memory access.
+==39042==Hint: address points to the zero page.
+    #0 0x55ef321a9e67 in exec_command_out /tmp/cirrus-ci-build/src/bin/psql/command.c:2497
+    #1 0x55ef321b36e6 in exec_command /tmp/cirrus-ci-build/src/bin/psql/command.c:406
+    #2 0x55ef321b3bd9 in HandleSlashCmds /tmp/cirrus-ci-build/src/bin/psql/command.c:242
+    #3 0x55ef321df248 in MainLoop /tmp/cirrus-ci-build/src/bin/psql/mainloop.c:496
+    #4 0x55ef321b0713 in process_file /tmp/cirrus-ci-build/src/bin/psql/command.c:4925
+    #5 0x55ef321fb6b7 in main /tmp/cirrus-ci-build/src/bin/psql/startup.c:420
+    #6 0x7ffbf3166249  (/lib/x86_64-linux-gnu/libc.so.6+0x27249)
+    #7 0x7ffbf3166304 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x27304)
+    #8 0x55ef321a3010 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/psql+0xb9010)
+
+AddressSanitizer can not provide additional info.
+SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/bin/psql/command.c:2497 in exec_command_out
+==39042==ABORTING
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out	2025-05-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out	2025-05-15 23:59:43.184030098 +0000
@@ -342,21 +342,9 @@
 "It is ""perfect"".","	"
 "",
 \copy y TO stdout (FORMAT CSV)
-"Jackson, Sam",\h
-"It is ""perfect"".",	
-"",
 \copy y TO stdout (FORMAT CSV, QUOTE '''', DELIMITER '|')
-Jackson, Sam|\h
-It is "perfect".|	
-''|
 \copy y TO stdout (FORMAT CSV, FORCE_QUOTE (col2), ESCAPE E'\\')
-"Jackson, Sam","\\h"
-"It is \"perfect\".","	"
-"",
 \copy y TO stdout (FORMAT CSV, FORCE_QUOTE *)
-"Jackson, Sam","\h"
-"It is ""perfect"".","	"
-"",
 --test that we read consecutive LFs properly
 CREATE TEMP TABLE testnl (a int, b text, c int);
 COPY testnl FROM stdin CSV;