Improve errmsg for publication membership

Started by Peter Smith21 days ago3 messageshackers
Jump to latest
#1Peter Smith
smithpb2250@gmail.com

Here is a patch to reword 2 publication error messages:

BEFORE/AFTER
"relation \"%s\" is already member of publication \"%s\"",
"relation \"%s\" is already a member of publication \"%s\"",

BEFORE/AFTER
"schema \"%s\" is already member of publication \"%s\"",
"schema \"%s\" is already a member of publication \"%s\"",

~~~

All other 'member of' error messages in PostgreSQL source are using
correct grammar ('a member of'), so IMO these should do likewise.

PSA v1.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

Attachments:

v1-0001-fix-errmsg-grammar-for-publication-membership.patchapplication/octet-stream; name=v1-0001-fix-errmsg-grammar-for-publication-membership.patchDownload+4-5
#2Ewan Young
kdbase.hack@gmail.com
In reply to: Peter Smith (#1)
Re: Improve errmsg for publication membership

On Wed, Jun 3, 2026 at 1:10 PM Peter Smith <smithpb2250@gmail.com> wrote:

Here is a patch to reword 2 publication error messages:

BEFORE/AFTER
"relation \"%s\" is already member of publication \"%s\"",
"relation \"%s\" is already a member of publication \"%s\"",

BEFORE/AFTER
"schema \"%s\" is already member of publication \"%s\"",
"schema \"%s\" is already a member of publication \"%s\"",

~~~

All other 'member of' error messages in PostgreSQL source are using
correct grammar ('a member of'), so IMO these should do likewise.

PSA v1.

Thanks. Patch applies cleanly on master, the wording fix matches all other
'member of' messages in the tree, and make check passes (245/245). LGTM.

Regards,
Ewan

Show quoted text

======
Kind Regards,
Peter Smith.
Fujitsu Australia

#3Amit Kapila
amit.kapila16@gmail.com
In reply to: Ewan Young (#2)
Re: Improve errmsg for publication membership

On Wed, Jun 3, 2026 at 11:35 AM Ewan Young <kdbase.hack@gmail.com> wrote:

On Wed, Jun 3, 2026 at 1:10 PM Peter Smith <smithpb2250@gmail.com> wrote:

Here is a patch to reword 2 publication error messages:

BEFORE/AFTER
"relation \"%s\" is already member of publication \"%s\"",
"relation \"%s\" is already a member of publication \"%s\"",

BEFORE/AFTER
"schema \"%s\" is already member of publication \"%s\"",
"schema \"%s\" is already a member of publication \"%s\"",

~~~

All other 'member of' error messages in PostgreSQL source are using
correct grammar ('a member of'), so IMO these should do likewise.

PSA v1.

Thanks. Patch applies cleanly on master, the wording fix matches all other
'member of' messages in the tree, and make check passes (245/245). LGTM.

LGTM as well. I think it is a minor inconsistency and we should fix it
only in HEAD. If so, we can probably wait for the PG20 branch to open
as this is not newly introduced in PG19.

--
With Regards,
Amit Kapila.