Horton

Fixes in ALTER SUBSCRIPTION DROP PUBLICATION code

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: e59d428f34297cd0eb67e3b4e4b8c8bc58504921
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2021-06-25T07:57:02Z
Releases: 14.0 
Fixes in ALTER SUBSCRIPTION DROP PUBLICATION code

ALTER SUBSCRIPTION DROP PUBLICATION does not actually support
copy_data option, so remove it from tab completion.

Also, reword the error message that is thrown when all the
publications from a subscription are specified to be dropped.

Also, made few doc and cosmetic adjustments.

Author: Vignesh C <vignesh21@gmail.com>
Reviewed-by: Bharath Rupireddy <bharath.rupireddy@enterprisedb.com>
Reviewed-by: Japin Li <japinli@hotmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CALDaNm21RwsDzs4xj14ApteAF7auyyomHNnp+NEL-sH8m-jMvQ@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/alter_subscription.sgml modified +10 −9
src/backend/commands/subscriptioncmds.c modified +3 −3
src/bin/psql/tab-complete.c modified +6 −2
src/test/regress/expected/subscription.out modified +1 −1

Documentation touched

Discussion