RE: Added schema level support for publication.

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

From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>

To: vignesh C <vignesh21@gmail.com>

Cc: "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>, Greg Nancarrow <gregn4422@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Smith <smithpb2250@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>, Amit Kapila <amit.kapila16@gmail.com>, "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>

Date: 2021-10-18T06:13:44Z

Lists: pgsql-hackers

Attachments

v41-0004-Documentation-for-FOR-ALL-TABLES-IN-SCHEMA-publi.patch (application/octet-stream) patch v41-0004
v41-0005-Implemented-pg_publication_objects-view.patch (application/octet-stream) patch v41-0005
v41-0001-Added-schema-level-support-for-publication.patch (application/octet-stream) patch v41-0001
v41-0002-Client-side-changes-to-support-FOR-ALL-TABLES-IN.patch (application/octet-stream) patch v41-0002
v41-0003-Tests-for-FOR-ALL-TABLES-IN-SCHEMA-publication.patch (application/octet-stream) patch v41-0003

On Saturday, October 16, 2021 1:57 PM houzj.fnst@fujitsu.com wrote:
> Based on the V40 patchset, attaching the Top-up patch which try to fix the
> partition issue in a cleaner way.

Attach the new version patch set which merge the partition fix into it.
Besides, instead of introducing new function and parameter, just add the
partition filter in pg_get_publication_tables which makes the code cleaner.

Only 0001 and 0003 was changed.

Best regards,
Hou zj

Commits

Include schema/table publications even with exclude options in dump.
- 4aa6fa3cd0a2 18.0 landed
Rename some enums to use TABLE instead of REL.
- b3812d0b9bcf 15.0 landed
Add tap tests for the schema publications.
- 6b0f6f79eef2 15.0 landed
Allow publishing the tables of schema.
- 5a2832465fd8 15.0 landed
In pg_dump, use simplehash.h to look up dumpable objects by OID.
- 92316a4582a5 15.0 cited