Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 18 Oct 2022 09:46:58 +0000 (11:46 +0200)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 18 Oct 2022 09:46:58 +0000 (11:46 +0200)
commit915a6c4e22ecc4775b9ed18312bf12d896cd2b11
treec6d98e6970406e2fc0b46c53ec53cccd3e5232f7
parenteddc128beac0f6e7b87e003888b0e947f7548e8a
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
src/backend/commands/subscriptioncmds.c