diff options
| author | Amit Kapila <akapila@postgresql.org> | 2023-06-21 10:07:47 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2023-06-21 10:22:07 +0530 |
| commit | 4b4ee1e2b073ffe719e7ad1bb1c22253fb1096e2 (patch) | |
| tree | e03ced65760460e215eb6c8b96a8d8e2e87769e4 /src | |
| parent | 2f97105e93c286a1377ddc0e2c9c7a5af4a2eee3 (diff) | |
| download | postgresql-4b4ee1e2b073ffe719e7ad1bb1c22253fb1096e2.tar.gz postgresql-4b4ee1e2b073ffe719e7ad1bb1c22253fb1096e2.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')
| -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 c99c943a206..40356e97ed2 100644 --- a/src/backend/commands/subscriptioncmds.c +++ b/src/backend/commands/subscriptioncmds.c @@ -992,7 +992,8 @@ DropSubscription(DropSubscriptionStmt *stmt, bool isTopLevel) "drop the replication slot \"%s\"", slotname), errdetail("The error was: %s", 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)"))); PG_TRY(); |