On Mon, Sep 5, 2022 at 8:46 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Mon, Sep 5, 2022 at 3:46 PM Peter Smith <smithpb2...@gmail.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
v8-0001-Column-List-new-pgdocs-section.patch
Description: Binary data
