On Jan 25, 2007, at 5:33 PM, Jan Wieck wrote:
A new per session GUC variable, restricted to superusers, will
define if the session is in origin or replica mode.
It would be nice if we had a separate role for replication services
so that we weren't exposing superuser so much. IIRC Oracle even
Jan Wieck <[EMAIL PROTECTED]> writes:
>>> A fires always
>>> N fires never
>>> O fires on transaction origin only
>>> R fires on replica only
> Good question. I don't know. I'd rather error on the safe side and make
> it multiple states, for now I only have Normal and Replica mode.
Hm, "
Jan Wieck <[EMAIL PROTECTED]> 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 sessio
The experience with Slony-I has shown that
a) different behavior of triggers and rules on a transactions origin
and a replica is essential;
b) mucking around with the system catalog to achieve this is futile.
This would be even more catastrophic in a multimaster environment, where
reg