Thread: pgsql: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION

pgsql: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION

From
Alvaro Herrera
Date:
Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION

The original hint says to use SET PUBLICATION when really ADD/DROP
PUBLICATION is called for, so this is arguably a bug fix.

Also, a very similar message elsewhere was using an inconsistent
SQLSTATE.

While at it, unwrap some strings.

Backpatch to 15.

Author: Hou zj <houzj.fnst@fujitsu.com>
Discussion: https://postgr.es/m/OS0PR01MB57160AD0E7386547BA978EB394299@OS0PR01MB5716.jpnprd01.prod.outlook.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/915a6c4e22ecc4775b9ed18312bf12d896cd2b11

Modified Files
--------------
src/backend/commands/subscriptioncmds.c | 27 ++++++++++++++++-----------
1 file changed, 16 insertions(+), 11 deletions(-)