I noticed that the Description section of the ALTER PUBLICATION page
[1] has a poorly worded sentence:
"Note that adding tables/except tables/schemas to a publication that
is already subscribed to will require an ALTER SUBSCRIPTION ...
REFRESH PUBLICATION action"
The problem is due to that strange slash-list. Apart from being
difficult to read, it makes it sound as if there's a distinct object
called an "except table", when what's meant is "changing a
publication's EXCEPT list."
PSA patch v1 to reword this using plain English.
~~~
In passing, I've also dropped the word "unset". Mentioning "unset"
only for ALL SEQUENCES (and not ALL TABLES) reads as an unexplained
asymmetry. Turning off ALL TABLES is already covered (e.g by "setting
tables or schemas" and by "set ALL SEQUENCES"), so spelling out
"unset" separately for ALL SEQUENCES isn't needed either -- unsetting
it is just another form of setting something else.
======
[1] https://www.postgresql.org/docs/19/sql-alterpublication.html
Kind Regards,
Peter Smith.
Fujitsu Australia
