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