Horton

RE: why can't a table be part of the same publication as its schema

Zhijie Hou (Fujitsu) <houzj.fnst@fujitsu.com>

View thread View on postgr.es
From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Date: 2022-09-17T04:47:57Z
Lists: pgsql-hackers

Attachments

On Saturday, September 17, 2022 11:22 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> 
> On Fri, Sep 16, 2022 at 1:09 PM houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com>
> wrote:
> >
> > Attach the new version patch which addressed above comments and ran
> pgident.
> > I also improved some codes and documents based on some comments given
> > by Vignesh and Peter offlist.
> >
> 
> Thanks, the patch looks mostly good to me. I have made a few cosmetic changes
> and edited a few comments. I would like to push this to HEAD and backpatch it
> to 15 by Tuesday unless there are any comments. I think we should back patch
> this because otherwise, users will see a change in behavior in 16 but if others
> don't think the same way then we can consider pushing this to HEAD only.

Thanks for the patch.
I rebased it based on PG15 and here is the patch.

Best regards,
Hou zj

Commits

  1. Allow publications with schema and table of the same schema.