On 5/22/17 18:08, Jeff Janes wrote: > If I create a publication FOR ALL TABLES and then change my mind, the > only thing I can do is drop the publication and recreate it. > > Since "ALTER PUBLICATION name SET TABLE" allows you to replace the > entire table list, shouldn't it also let you change from the dynamic FOR > ALL TABLES to a static specific list?
I would file this under "anything is possible, but not everything is worthwhile". The purpose of the ADD/SET TABLE clauses is that be able to add new tables that are related to the tables you are already publishing (e.g., new partitions). If you are already publishing all tables automatically, then there is no reason for replacing that with a list of specific tables. You can also just add a new publication and add that to the subscription. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers