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

From Greg Nancarrow
Subject Re: Added schema level support for publication.
Date
Msg-id CAJcOf-ezOOSCfq1L8AWMUJx=ex=7ECruiVV79ZfbHY_a7e8O1w@mail.gmail.com
Whole thread Raw
In response to Re: Added schema level support for publication.  (vignesh C <vignesh21@gmail.com>)
Responses Re: Added schema level support for publication.  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
On Thu, Oct 21, 2021 at 3:25 AM vignesh C <vignesh21@gmail.com> wrote:
>
> Attached v44 patch as the fixes for the same.
>

Regarding the documentation, I think some minor updates are needed in:
 doc/src/sgml/logical-replication.sgml.
For example, currently it says:
   Publications may currently only contain tables. Objects must be
added explicitly, except when a publication is created for
<literal>ALL TABLES</literal>.
There is also some security-related information in this file which may
need updating for ALL TABLES IN SCHEMA.

Also, I'm not sure the documentation updates in the patches clearly
define how partitions relate to ALL TABLES IN SCHEMA.
For example, if a partitioned table belongs to a different schema to
that of a child partition that belongs to a schema specified for ALL
TABLES IN SCHEMA, is it implicitly included in the publication or not
included?

Regards,
Greg Nancarrow
Fujitsu Australia



pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: parallelizing the archiver
Next
From: Masahiko Sawada
Date:
Subject: Re: Failed transaction statistics to measure the logical replication progress