Re: Added schema level support for publication.

vignesh C <vignesh21@gmail.com>

From: vignesh C <vignesh21@gmail.com>

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

Cc: Greg Nancarrow <gregn4422@gmail.com>, Amit Kapila <amit.kapila16@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>, "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>, Ajin Cherian <itsajin@gmail.com>, Rahila Syed <rahilasyed90@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

Date: 2021-09-27T04:32:01Z

Lists: pgsql-hackers

Attachments

v33-0001-Added-schema-level-support-for-publication.patch (text/x-patch) patch v33-0001
v33-0002-Client-side-changes-to-support-FOR-ALL-TABLES-IN.patch (text/x-patch) patch v33-0002
v33-0003-Tests-for-FOR-ALL-TABLES-IN-SCHEMA-publication.patch (text/x-patch) patch v33-0003
v33-0004-Documentation-for-FOR-ALL-TABLES-IN-SCHEMA-publi.patch (text/x-patch) patch v33-0004
v33-0005-Implemented-pg_publication_objects-view.patch (text/x-patch) patch v33-0005
v33-0006-Alternate-grammar-for-ALL-TABLES-IN-SCHEMA.patch (text/x-patch) patch v33-0006

On Fri, Sep 24, 2021 at 11:46 AM vignesh C <vignesh21@gmail.com> wrote:
>

Attached v33 patch has the preprocess_pubobj_list review comment fix
suggested by Alvaro at [1]. The
v33-0006-Alternate-grammar-for-ALL-TABLES-IN-SCHEMA.patch patch has
the grammar changes as suggested by Alvaro at [1]. If we agree this is
better, I will merge this into the 0001 patch.
[1] - https://www.postgresql.org/message-id/202109241325.eag5g6mpvoup%40alvherre.pgsql

Regards,
Vignesh

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