Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: 25fb9579bbb97c65d6b007c3de803c81abb4b240
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2022-10-18T09:46:58Z
Releases: 15.1
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

Files

PathChange+/−
src/backend/commands/subscriptioncmds.c modified +16 −11

Discussion