diff options
| author | Amit Kapila <akapila@postgresql.org> | 2023-06-21 10:36:09 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2023-06-21 10:36:09 +0530 |
| commit | a734caa25f79b7bfa423dd97162e5ecf14d1feb5 (patch) | |
| tree | 3b654a943d2d9111f8f56ffbc224699366b7e310 /src/backend/commands/subscriptioncmds.c | |
| parent | 5b1a8799431279b5f9d56c81b0d0879415e7b45c (diff) | |
| download | postgresql-a734caa25f79b7bfa423dd97162e5ecf14d1feb5.tar.gz postgresql-a734caa25f79b7bfa423dd97162e5ecf14d1feb5.zip | |
Fix the errhint message and docs for drop subscription failure.
The existing errhint message and docs were missing the fact that we can't
disassociate from the slot unless the subscription is disabled.
Author: Robert Sjöblom, Peter Smith
Reviewed-by: Peter Eisentraut, Amit Kapila
Backpatch-through: 11
Discussion: https://postgr.es/m/807bdf85-61ea-88e2-5712-6d9fcd4eabff@fortnox.se
Diffstat (limited to 'src/backend/commands/subscriptioncmds.c')
| -rw-r--r-- | src/backend/commands/subscriptioncmds.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/commands/subscriptioncmds.c b/src/backend/commands/subscriptioncmds.c index 1c88c2bccbf..54895ba929a 100644 --- a/src/backend/commands/subscriptioncmds.c +++ b/src/backend/commands/subscriptioncmds.c @@ -2185,7 +2185,8 @@ ReportSlotConnectionError(List *rstates, Oid subid, char *slotname, char *err) errmsg("could not connect to publisher when attempting to drop replication slot \"%s\": %s", slotname, err), /* translator: %s is an SQL ALTER command */ - errhint("Use %s to disassociate the subscription from the slot.", + errhint("Use %s to disable the subscription, and then use %s to disassociate it from the slot.", + "ALTER SUBSCRIPTION ... DISABLE", "ALTER SUBSCRIPTION ... SET (slot_name = NONE)"))); } |