diff options
| author | Amit Kapila <akapila@postgresql.org> | 2022-10-13 06:09:43 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2022-10-13 06:09:43 +0530 |
| commit | 5263c6b095c9bac2a4a744b72425e6690121c79d (patch) | |
| tree | 1d9a5dfc90489408f24256971bcf5a4227ea0650 /src/backend/commands/subscriptioncmds.c | |
| parent | 56b662523fd49f75abe89d5bad54d377b2f36c24 (diff) | |
Improve the WARNING message for CREATE SUBSCRIPTION.
Author: Peter Smith
Reviewed-By: Alvaro Herrera, Tom Lane, Amit Kapila
Discussion: https://postgr.es/m/CAHut+PvqdqOanheWSHDyhQiF+Z-7w=-+k4U+bwbT=b6YQ_hrXQ@mail.gmail.com
Diffstat (limited to 'src/backend/commands/subscriptioncmds.c')
| -rw-r--r-- | src/backend/commands/subscriptioncmds.c | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/src/backend/commands/subscriptioncmds.c b/src/backend/commands/subscriptioncmds.c index 97594cd9b18..8fb89a9392c 100644 --- a/src/backend/commands/subscriptioncmds.c +++ b/src/backend/commands/subscriptioncmds.c @@ -760,9 +760,8 @@ CreateSubscription(ParseState *pstate, CreateSubscriptionStmt *stmt, } else ereport(WARNING, - /* translator: %s is an SQL ALTER statement */ - (errmsg("tables were not subscribed, you will have to run %s to subscribe the tables", - "ALTER SUBSCRIPTION ... REFRESH PUBLICATION"))); + (errmsg("subscription was created, but is not connected"), + errhint("To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the subscription."))); table_close(rel, RowExclusiveLock); |