Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY - Mailing list pgsql-hackers

From Peter Smith
Subject Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY
Date
Msg-id CAHut+Psw4ZPeUxd3Pyhk3Zq7yJ1hYgpohW1D3qUdS1CeZXA1_Q@mail.gmail.com
Whole thread
In response to Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Mon, Apr 20, 2026 at 3:45 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Mon, Apr 20, 2026 at 5:44 AM Peter Smith <smithpb2250@gmail.com> wrote:
> >
> > On Fri, Apr 17, 2026 at 8:44 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > >
> > > On Fri, Apr 17, 2026 at 5:26 AM Peter Smith <smithpb2250@gmail.com> wrote:
> > > >
> > > > Currently, the EXCEPT (TABLE ...) part mentions how 'ONLY' and '*'
> > > > work for inheritance tables, but how they have no effect for
> > > > partitioned tables [1].
> > > >
> > > > It seems we accidentally missed saying that these also have no effect
> > > > for *regular* tables.
> > > >
> > >
> > > The sentence you quoted speaks about partitioned tables specifically,
> > > so not mentioning regular tables there seems reasonable to me.
> > >
> >
> > I think you missed my point.
> >
>
> No, I understood the point but didn't find it useful to add this to
> regular tables because they won't have children in any form.
>

Because regular tables won't have children in any form, a user could
reasonably worry that saying ONLY or `*` might give a runtime error or
a warning. There is no documentation to say otherwise. The patch
addresses that gap.

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



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+
Next
From: lakshmi
Date:
Subject: Re: ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.”