ALTER PUBLICATION materializing the list of tables

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ALTER PUBLICATION materializing the list of tables
Date: 2017-05-22 22:08:35
Message-ID: CAMkU=1w=_LTtYqymfCAu-vSeZZq8A=VUPT3DGceH+fwb0qbmLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2017-05-22 22:39:18 Re: PG10 Crash-safe and replicable Hash Indexes and UNIQUE
Previous Message Jeff Janes 2017-05-22 21:50:08 ALTER PUBLICATION documentation