Re: A doubt about a newly added errdetail

On 2022-Sep-26, Kyotaro Horiguchi wrote:

> I saw the following message recently added to publicationcmds.c.
>
> (ERROR: cannot use publication column list for relation "%s.%s"")
> > DETAIL: Column list cannot be specified if any schema is part of the publication or specified in the list.
>
> As my reading, the "the list" at the end syntactically means "Column
> list" but that is actually wrong; it could be read as "the list
> following TABLES IN" but that doesn't seem reasonable.
>
> If I am right, it might should be something like the following:
>
> + Column list cannot be specified if any schema is part of the publication or specified in the command.
> + Column list cannot be specified if any schema is part of the publication or specified together.

I propose

ERROR: cannot use column list for relation "%s.%s" in publication "%s"
DETAIL: Column lists cannot be specified in publications containing FOR TABLES IN SCHEMA elements.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/