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
elein at varlena.com


> 
> Sven
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>