Re: Column Filtering in Logical Replication

On Mon, Sep 5, 2022 at 8:46 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Mon, Sep 5, 2022 at 3:46 PM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> >
> >
> > PSA v7.
> >
>
> For example, if additional columns are added to the table, then
> + (after a <literal>REFRESH PUBLICATION</literal>) if there was a column list
> + only those named columns will continue to be replicated.
>
> This looks a bit unclear to me w.r.t the refresh publication step. Why
> exactly you have used refresh publication in the above para? It is
> used to add new tables if any added to the publication, so not clear
> to me how it helps in this case. If that is not required then we can
> change it to: "For example, if additional columns are added to the
> table then only those named columns mentioned in the column list will
> continue to be replicated."
>

You are right - that REFRESH PUBLICATION was not necessary for this
example. The patch is modified to use your suggested text.

PSA v8

------
Kind Regards,
Peter Smith.
Fujitsu Australia