Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY

On Mon, Apr 20, 2026 at 3:45 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Mon, Apr 20, 2026 at 5:44 AM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> >
> > On Fri, Apr 17, 2026 at 8:44 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > >
> > > On Fri, Apr 17, 2026 at 5:26 AM Peter Smith <smithpb2250(at)gmail(dot)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