Re: Added schema level support for publication. - Mailing list pgsql-hackers

From vignesh C
Subject Re: Added schema level support for publication.
Date
Msg-id CALDaNm10eiWGT0mFZA1HsSOtO4CW84Sq0h3Nuqi-WOFPEvV_Mw@mail.gmail.com
Whole thread Raw
In response to Re: Added schema level support for publication.  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Added schema level support for publication.  (Greg Nancarrow <gregn4422@gmail.com>)
RE: Added schema level support for publication.  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
Re: Added schema level support for publication.  (Greg Nancarrow <gregn4422@gmail.com>)
List pgsql-hackers
On Wed, Oct 20, 2021 at 12:32 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Tue, Oct 19, 2021 at 9:42 PM vignesh C <vignesh21@gmail.com> wrote:
> >
>
> Thanks for the modified patch. I have a few more comments and suggestions:
>
> As the thread [1] is still not concluded, I suggest we fix the
> duplicate data case only when schemas are involved by slightly
> tweaking the code as per attached. This is just to give you an idea
> about what I have in mind, if you find a better solution then feel
> free to let me know.
>
> Few additional minor comments:
> 1.
> +-- Test the list of partitions published
>
> Shall we change the above comment as: "Test the list of partitions
> published with or without 'PUBLISH_VIA_PARTITION_ROOT' parameter"?

Modified

> 2. psql documentation for \dRp[+] needs to be modified.
>
> \dRp
> Before:
> " .. If + is appended to the command name, the tables associated with
> each publication are shown as well."
> After:
> " .. If + is appended to the command name, the tables and schemas
> associated with each publication are shown as well.

Modified

> Apart from the above, I think we should merge the first four patches
> as there doesn't seem to be any big problems pending. We can keep
> still keep tests added by 025_rep_changes_for_schema.pl as a separate
> patch as there might be some timing-dependent tests in that file.

This version of patch retains the changes related to
PublicationRelInfo, I will handle the merging of the patches in the
next version so that this version of patch change related to
PublicationRelInfo can be reviewed easily.

Attached v44 patch as the fixes for the same.

Regards,
Vignesh

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pgsql: Document XLOG_INCLUDE_XID a little better
Next
From: "David G. Johnston"
Date:
Subject: Re: Some questions about schema privileges