diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out --- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-11-07 11:14:47.567574000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-11-07 11:18:09.990434000 +0000 @@ -527,7 +527,9 @@ -- configurations and checking the DDL. -- CREATE ROLE createsub_role LOGIN; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE ROLE readalldata_role LOGIN; +WARNING: roles created by regression test cases should have names starting with "regress_" -- see the pg_get_subscription_ddl output for a NULL and empty input SELECT pg_get_subscription_ddl(''); ERROR: subscription "" does not exist @@ -540,6 +542,7 @@ -- Create subscription with minimal options CREATE SUBSCRIPTION testsub1 CONNECTION 'dbname=db_doesnotexist' PUBLICATION testpub1 WITH (connect=false); +WARNING: subscriptions created by regression test cases should have names starting with "regress_" WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications. -- Check that the subscription ddl is correctly created @@ -553,6 +556,7 @@ CREATE SUBSCRIPTION "TestSubddL2" CONNECTION 'host=unknown user=dvd password=pass123' PUBLICATION "testpub2", "TestPub3" WITH (connect=false, slot_name='slot1', enabled=off); +WARNING: subscriptions created by regression test cases should have names starting with "regress_" WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications. SELECT pg_get_subscription_ddl('TestSubddL2'); @@ -568,6 +572,7 @@ synchronous_commit=local, two_phase=true, disable_on_error=true, password_required=false, run_as_owner=true, origin=none, failover=true, retain_dead_tuples=false, max_retention_duration=100); +WARNING: subscriptions created by regression test cases should have names starting with "regress_" NOTICE: max_retention_duration is ineffective when retain_dead_tuples is disabled WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications.