On Sun, Apr 16, 2017 at 11:58 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> By the way, Petr said in the other thread that it could be made a no-op
> (presumably without requiring IF NOT EXISTS) on the grounds that
> membership of table in publication is "soft object" or "property" rather
> than real object.
I don't find that argument terribly convincing.
The nearest parallel that we have for this is probably:
ALTER EXTENSION name ADD member_object;
ALTER EXTENSION name DROP member_object;
I would guess this ought to work similarly.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company