Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] ALTER PUBLICATION materializing the list of tables - Mailing list pgsql-hackers

From Jeff Janes
Subject [HACKERS] ALTER PUBLICATION materializing the list of tables
Date
Msg-id CAMkU=1w=_LTtYqymfCAu-vSeZZq8A=VUPT3DGceH+fwb0qbmLA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] ALTER PUBLICATION materializing the list of tables  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view

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?

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: [HACKERS] ALTER PUBLICATION documentation
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] PG10 Crash-safe and replicable Hash Indexes and UNIQUE