diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_table.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-11-25 20:17:33.679991920 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-11-25 20:20:55.274482224 +0000 @@ -44,97 +44,7 @@ CREATE TABLE part ( a int ) PARTITION BY RANGE (a); -NOTICE: DDL test: type simple, tag CREATE TABLE -CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100); -NOTICE: DDL test: type simple, tag CREATE TABLE -CREATE TABLE part2 (a int); -NOTICE: DDL test: type simple, tag CREATE TABLE -ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200); -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ATTACH PARTITION desc table part2 -ALTER TABLE part DETACH PARTITION part2; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type DETACH PARTITION desc table part2 -DROP TABLE part2; -ALTER TABLE part ADD PRIMARY KEY (a); -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint part_a_not_null on table part -NOTICE: subcommand: type ADD INDEX desc index part_pkey -ALTER TABLE parent ALTER COLUMN a SET NOT NULL; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET NOT NULL (and recurse) desc constraint parent_a_not_null on table parent -ALTER TABLE parent ALTER COLUMN a DROP NOT NULL; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type DROP NOT NULL (and recurse) desc column a of table parent -ALTER TABLE parent ALTER COLUMN a SET NOT NULL; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET NOT NULL (and recurse) desc constraint parent_a_not_null on table parent -ALTER TABLE parent ALTER COLUMN a ADD GENERATED ALWAYS AS IDENTITY; -NOTICE: DDL test: type simple, tag CREATE SEQUENCE -NOTICE: DDL test: type simple, tag ALTER SEQUENCE -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ADD IDENTITY (and recurse) desc column a of table parent -ALTER TABLE parent ALTER COLUMN a SET GENERATED BY DEFAULT; -NOTICE: DDL test: type simple, tag ALTER SEQUENCE -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET IDENTITY (and recurse) desc column a of table parent -ALTER TABLE parent ALTER COLUMN a DROP IDENTITY; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type DROP IDENTITY (and recurse) desc column a of table parent -ALTER TABLE parent ALTER COLUMN a SET STATISTICS 100; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET STATS desc column a of table parent -NOTICE: subcommand: type SET STATS desc column a of table child -NOTICE: subcommand: type SET STATS desc column a of table grandchild -ALTER TABLE parent ALTER COLUMN a SET STORAGE PLAIN; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET STORAGE desc column a of table parent -NOTICE: subcommand: type SET STORAGE desc column a of table child -NOTICE: subcommand: type SET STORAGE desc column a of table grandchild -ALTER TABLE parent ENABLE ROW LEVEL SECURITY; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ENABLE ROW SECURITY desc -ALTER TABLE parent NO FORCE ROW LEVEL SECURITY; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type NO FORCE ROW SECURITY desc -ALTER TABLE parent FORCE ROW LEVEL SECURITY; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type FORCE ROW SECURITY desc -ALTER TABLE parent DISABLE ROW LEVEL SECURITY; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type DISABLE ROW SECURITY desc -CREATE STATISTICS parent_stat (dependencies) ON a, c FROM parent; -NOTICE: DDL test: type simple, tag CREATE STATISTICS -ALTER TABLE parent ALTER COLUMN c TYPE numeric; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table parent -NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table child -NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table grandchild -NOTICE: subcommand: type (re) ADD CONSTRAINT desc constraint parent_b_not_null on table parent -NOTICE: subcommand: type (re) ADD STATS desc statistics object parent_stat -ALTER TABLE parent ALTER COLUMN c SET DEFAULT 0; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table parent -NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table child -NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table grandchild -CREATE TABLE tbl ( - a int generated always as (b::int * 2) stored, - b text -); -NOTICE: DDL test: type simple, tag CREATE TABLE -ALTER TABLE tbl ALTER COLUMN a DROP EXPRESSION; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type DROP EXPRESSION desc column a of table tbl -ALTER TABLE tbl ALTER COLUMN b SET COMPRESSION pglz; -NOTICE: DDL test: type alter table, tag ALTER TABLE -NOTICE: subcommand: type SET COMPRESSION desc column b of table tbl -CREATE TYPE comptype AS (r float8); -NOTICE: DDL test: type simple, tag CREATE TYPE -CREATE DOMAIN dcomptype AS comptype; -NOTICE: DDL test: type simple, tag CREATE DOMAIN -ALTER DOMAIN dcomptype ADD CONSTRAINT c1 check ((value).r > 0); -NOTICE: DDL test: type simple, tag ALTER DOMAIN -ALTER TYPE comptype ALTER ATTRIBUTE r TYPE bigint; -NOTICE: DDL test: type alter table, tag ALTER TYPE -NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column r of composite type comptype -NOTICE: subcommand: type (re) ADD DOMAIN CONSTRAINT desc type dcomptype +server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. +connection to server was lost diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_view.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_view.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_view.out 2025-11-25 20:17:33.692887842 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_view.out 2025-11-25 20:20:55.291575280 +0000 @@ -1,19 +1 @@ --- --- CREATE_VIEW --- -CREATE VIEW static_view AS - SELECT 'foo'::TEXT AS col; -NOTICE: DDL test: type simple, tag CREATE VIEW -CREATE OR REPLACE VIEW static_view AS - SELECT 'bar'::TEXT AS col; -NOTICE: DDL test: type simple, tag CREATE VIEW -NOTICE: DDL test: type alter table, tag CREATE VIEW -NOTICE: subcommand: type REPLACE RELOPTIONS desc -CREATE VIEW datatype_view AS - SELECT * FROM datatype_table; -NOTICE: DDL test: type simple, tag CREATE VIEW -CREATE RECURSIVE VIEW nums_1_100 (n) AS - VALUES (1) -UNION ALL - SELECT n+1 FROM nums_1_100 WHERE n < 100; -NOTICE: DDL test: type simple, tag CREATE VIEW +psql: error: connection to server on socket "/tmp/pg_regress-xC4Guw/.s.PGSQL.40073" failed: FATAL: the database system is in recovery mode diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_trigger.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_trigger.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_trigger.out 2025-11-25 20:17:33.691331364 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_trigger.out 2025-11-25 20:20:55.302640809 +0000 @@ -1,18 +1,2 @@ ---- ---- CREATE_TRIGGER ---- -CREATE FUNCTION plpgsql_function_trigger_1() - RETURNS TRIGGER - LANGUAGE plpgsql -AS $$ -BEGIN - RETURN NEW; -END; -$$; -NOTICE: DDL test: type simple, tag CREATE FUNCTION -CREATE TRIGGER trigger_1 - BEFORE INSERT OR UPDATE - ON datatype_table - FOR EACH ROW - EXECUTE PROCEDURE plpgsql_function_trigger_1(); -NOTICE: DDL test: type simple, tag CREATE TRIGGER +psql: error: connection to server on socket "/tmp/pg_regress-xC4Guw/.s.PGSQL.40073" failed: FATAL: the database system is not yet accepting connections +DETAIL: Consistent recovery state has not been yet reached. diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_rule.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_rule.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/create_rule.out 2025-11-25 20:17:33.687009464 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/create_rule.out 2025-11-25 20:20:55.321997629 +0000 @@ -1,26 +1,2 @@ ---- ---- CREATE_RULE ---- ---- Note: views' ON SELECT rules are tested elsewhere. ---- -CREATE RULE rule_1 AS - ON INSERT - TO datatype_table - DO NOTHING; -NOTICE: DDL test: type simple, tag CREATE RULE -CREATE RULE rule_2 AS - ON UPDATE - TO datatype_table - DO INSERT INTO unlogged_table (id) VALUES(NEW.id); -NOTICE: DDL test: type simple, tag CREATE RULE -CREATE RULE rule_3 AS - ON DELETE - TO datatype_table - DO ALSO NOTHING; -NOTICE: DDL test: type simple, tag CREATE RULE -CREATE RULE rule_3 AS - ON DELETE - TO like_datatype_table - WHERE id < 100 - DO ALSO NOTHING; -NOTICE: DDL test: type simple, tag CREATE RULE +psql: error: connection to server on socket "/tmp/pg_regress-xC4Guw/.s.PGSQL.40073" failed: FATAL: the database system is not yet accepting connections +DETAIL: Consistent recovery state has not been yet reached. diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/comment_on.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/comment_on.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/comment_on.out 2025-11-25 20:17:33.682400610 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/comment_on.out 2025-11-25 20:20:55.332809593 +0000 @@ -1,23 +1,2 @@ --- --- COMMENT_ON --- -COMMENT ON SCHEMA foo IS 'This is schema foo'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON TYPE enum_test IS 'ENUM test'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON TYPE int2range IS 'RANGE test'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON DOMAIN japanese_postal_code IS 'DOMAIN test'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON SEQUENCE fkey_table_seq IS 'SEQUENCE test'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON TABLE datatype_table IS 'This table should contain all native datatypes'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON VIEW datatype_view IS 'This is a view'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON FUNCTION c_function_test() IS 'FUNCTION test'; -ERROR: function c_function_test() does not exist -COMMENT ON TRIGGER trigger_1 ON datatype_table IS 'TRIGGER test'; -NOTICE: DDL test: type simple, tag COMMENT -COMMENT ON RULE rule_1 ON datatype_table IS 'RULE test'; -NOTICE: DDL test: type simple, tag COMMENT +psql: error: connection to server on socket "/tmp/pg_regress-xC4Guw/.s.PGSQL.40073" failed: FATAL: the database system is not yet accepting connections +DETAIL: Consistent recovery state has not been yet reached. diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_function.out /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_function.out --- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_function.out 2025-11-25 20:17:33.678358991 +0000 +++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_function.out 2025-11-25 20:20:55.346855706 +0000 @@ -1,15 +1,2 @@ --- --- ALTER_FUNCTION --- -ALTER FUNCTION plpgsql_function_trigger_1 () - SET SCHEMA foo; -NOTICE: DDL test: type simple, tag ALTER FUNCTION -ALTER FUNCTION foo.plpgsql_function_trigger_1() - COST 10; -NOTICE: DDL test: type simple, tag ALTER FUNCTION -CREATE ROLE regress_alter_function_role; -ALTER FUNCTION plpgsql_function_trigger_2() - OWNER TO regress_alter_function_role; -ERROR: function plpgsql_function_trigger_2() does not exist -DROP OWNED BY regress_alter_function_role; -DROP ROLE regress_alter_function_role; +psql: error: connection to server on socket "/tmp/pg_regress-xC4Guw/.s.PGSQL.40073" failed: FATAL: the database system is not yet accepting connections +DETAIL: Consistent recovery state has not been yet reached.