Postgres Pro
Downloads
Home   >   mailing lists

Re: Ambiguous description on new columns - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Ambiguous description on new columns
Date
Msg-id CAKFQuwbUuQu0_DbGBUyQ4DqYhR35Vm2_xsB1SY1nZHm5KcXhig@mail.gmail.com
Whole thread Raw
In response to Ambiguous description on new columns  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
On Tue, May 21, 2024 at 3:40 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/logical-replication-col-lists.html
Description:

The documentation on this page mentions:

"If no column list is specified, any columns added later are automatically
replicated."

It feels ambiguous what this could mean. Does it mean:

1/ That if you alter the table on the publisher and add a new column, it
will be replicated

Yes, this is the only thing in scope you can "add columns to later".


2/ If you add a column list later and add a column to it, it will be
replicated

I feel like we failed somewhere if the reader believes that it is possible to alter a publication in this way.

David J.

pgsql-docs by date:

Previous
From: Peter Smith
Date:
Subject: Re: Ambiguous description on new columns
Next
From: "David G. Johnston"
Date:
Subject: Re: Ambiguous description on new columns