Re: Proposal: Change of pg_trigger.tg_enabled and adding pg_rewrite.ev_enabled

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> The value definitions of tg_enabled would be

> A fires always
> N fires never
> O fires on transaction origin only
> R fires on replica only

> A new per session GUC variable, restricted to superusers, will define if
> the session is in origin or replica mode.

Are you sure two states are enough?

No particular objection, but now would be the time to think if a boolean
is sufficient.

> Likewise the system catalog pg_rewrite is extended with an attribute
> ev_enabled. It will have the same possible values and a new command,

I assume there'd be no intention of supporting on-the-fly changes of
this setting (ie, you'd set the GUC variable once at session startup
and not change thereafter)? Otherwise you'd have a problem with cached
plans.

regards, tom lane