On Thu, Oct 02, 2008 at 03:04:52PM -0500, Jeff Amiel wrote: > > hmmm....so what is the 'right way' > > > " The Right Way to handle such triggers is normally to use STORE > TRIGGER, which tells Slony-I that a trigger should not get deactivated." > > Does that mean putting the 'create trigger' in a SLONIK script isn't the > 'right way'?
No, these are two different uses. STORE TRIGGER installs the trigger in such a way that it _will_ fire on a replica. CREATE TRIGGER sent into the origin via EXECUTE SCRIPT creates the trigger on all nodes, then disables it on replicas. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
