Re: A doubt about a newly added errdetail - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: A doubt about a newly added errdetail
Date
Msg-id 20220926073949.mq6gl55fsl3ciuzq@alvherre.pgsql
Whole thread Raw
In response to A doubt about a newly added errdetail  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: A doubt about a newly added errdetail
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: "wangw.fnst@fujitsu.com"
Date:
Subject: RE: [RFC] building postgres with meson - v13
Next
From: Rushabh Lathia
Date:
Subject: DROP OWNED BY is broken on master branch.