On 11/12/16 2:18 PM, Andres Freund wrote:
>>> I also wonder if we want an easier to
>>> > > extend form of pubinsert/update/delete (say to add pubddl, pubtruncate,
>>> > > pub ... without changing the schema).
>>> > >
>> >
>> > So like, text array that's then parsed everywhere (I am not doing
>> > bitmask/int definitely)?
> Yes, that sounds good to me. Then convert it to individual booleans or a
> bitmask when loading the publications into the in-memory form (which you
> already do).
I'm not sure why that would be better. Adding catalog columns in future
versions is not a problem. We're not planning on adding hundreds of
publication attributes. Denormalizing catalog columns creates all kinds
of inconveniences, in the backend code, in frontend code, for users.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services