On Mon, Jul 17, 2006 at 12:45:07PM -0400, Sven Willenberger wrote: > 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.
It looks like STORE TRIGGER is a candidate for expansion in the perltools. Are there other slonik tasks that were added more recently that also did not get extended to perltools? --elein [EMAIL PROTECTED] > > Sven > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://gborg.postgresql.org/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
