Horton

RE: Added schema level support for publication.

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

View thread View on postgr.es
From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
To: vignesh C <vignesh21@gmail.com>
Cc: Greg Nancarrow <gregn4422@gmail.com>, Ajin Cherian <itsajin@gmail.com>, Rahila Syed <rahilasyed90@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>
Date: 2021-08-03T08:19:18Z
Lists: pgsql-hackers 
On Tuesday, August 3, 2021 4:10 PM houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com> wrote:
> On August 2, 2021 11:40 PM vignesh C <vignesh21@gmail.com> wrote:
> >
> > Thanks for the comments, attached v17 patches has the fixes for the same.
> 
> Thanks for the new patch, it looks good to me except one minor thing:
> It might be better to add the [CREATE PUBLICATION xxx FOR SCHEMA ] in
> tab-complete.c

Sorry, the patch already had the logic, please ignore this comment.

Best regards,
houzj

Commits

  1. Include schema/table publications even with exclude options in dump.

  2. Rename some enums to use TABLE instead of REL.

  3. Add tap tests for the schema publications.

  4. Allow publishing the tables of schema.

  5. In pg_dump, use simplehash.h to look up dumpable objects by OID.