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/