Horton

Re: Added schema level support for publication.

vignesh C <vignesh21@gmail.com>

View thread View on postgr.es
From: vignesh C <vignesh21@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>, "houzj.fnst@fujitsu.com" <houzj.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: 2025-02-19T12:48:15Z
Lists: pgsql-hackers

Attachments

On Wed, 19 Feb 2025 at 15:57, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Dec 18, 2024 at 12:51 PM vignesh C <vignesh21@gmail.com> wrote:
> >
> > The attached patch has the changes for the same.
> >
>
> @@ -3037,10 +3037,6 @@ my %tests = (
>   \QALTER PUBLICATION pub1 ADD TABLE ONLY dump_test.test_table;\E
>   /xm,
>   like => { %full_runs, section_post_data => 1, },
> - unlike => {
> - exclude_dump_test_schema => 1,
> - exclude_test_table => 1,
> - },
>
> Shall we change the above 'unlike' to 'like' instead of removing it
> with an additional comment as to why we expect a different behavior
> here?

The updated v2 version patch has the changes for the same.

Regards,
Vignesh

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.