From 1e7ca1189cccff9851d4f12dacadf6ffff4b04fa Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 16 Aug 2023 15:09:50 +0200 Subject: Improved CREATE SUBSCRIPTION message for clarity Discussion: https://www.postgresql.org/message-id/CAHut+PtfzQ7JRkb0-Y_UejAxaLQ17-bGMvV4MJJHcPoP3ML2bg@mail.gmail.com --- src/backend/commands/subscriptioncmds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/backend/commands/subscriptioncmds.c b/src/backend/commands/subscriptioncmds.c index d4e798baeb1..34d881fd94f 100644 --- a/src/backend/commands/subscriptioncmds.c +++ b/src/backend/commands/subscriptioncmds.c @@ -2023,8 +2023,8 @@ check_publications_origin(WalReceiverConn *wrconn, List *publications, errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE), errmsg("subscription \"%s\" requested copy_data with origin = NONE but might copy data that had a different origin", subname), - errdetail_plural("Subscribed publication %s is subscribing to other publications.", - "Subscribed publications %s are subscribing to other publications.", + errdetail_plural("The subscription being created subscribes to a publication (%s) that contains tables that are written to by other subscriptions.", + "The subscription being created subscribes to publications (%s) that contain tables that are written to by other subscriptions.", list_length(publist), pubnames->data), errhint("Verify that initial data copied from the publisher tables did not come from other origins.")); } -- cgit v1.2.3