Jan Wieck JanWieck at Yahoo.com
Tue Aug 17 10:14:14 PDT 2010
On 8/17/2010 2:21 AM, Scott Marlowe wrote:
> On Mon, Aug 16, 2010 at 10:24 AM, Christopher Browne
> <cbbrowne at ca.afilias.info> wrote:
>> Triggers on the table may still need to fire; they certainly did, on the
>> origin, and they may also need to, on subscribers.
> 
> Aren't all triggers disabled on slaves in slony (except slony
> triggers) by default?
> 

In 1.2 they are, unless you have told Slony via STORE TRIGGER not to do so.

In 2.0 you can control that on the subscriber with native PostgreSQL 
configuration options.

ALTER TABLE DISABLE/ENABLE [ REPLICA | ALWAYS ] TRIGGER


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin


More information about the Slony1-general mailing list