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
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/