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/