On Sun, 2006-07-16 at 19:25 -0700, Ujwal S. Setlur wrote: > Hi, > > I need to add a function and a trigger to an existing replication > system. I guess it's pretty straightforward to add it to an origin of > a set since all my user defined triggers are still active, but how do > I do it on a subscriber since the user defined triggers are currently > "disabled"? I need to add it to the subscriber in case it ever needs > to become the origin in the event of a failure of the intended origin. > > Thanks, > > Ujwal >
You can create the functions directly on each node; as far as creating the triggers, I would first use EXECUTE SCRIPT to run the ddl sql commands that make the triggers, then use STORE TRIGGER to make it visible on the subscriber node. Sven _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
