Hi.  I've been using Slony for a couple of years, and it's been working great;
but we've just started using triggers in our application, and when I manually
added the trigger on the subscriber side, next time I tried to recreate the
data set, it wouldn't go due to multiple triggers issue.  So how do I replicate
triggers, please?

-----------------------------------------------------------------------------------------------------

This is the issue I ran into after manually adding the trigger on the
subscriber:


NOTICE: Slony-I: alterTableForReplication(): multiple instances of
trigger % on table %'',

This normally happens if you have a table that had a trigger attached
to it that replication hid due to this being a subscriber node, and
then you added a trigger by the same name back to replication. Now,
when trying to "fix up" triggers, those two triggers conflict.

The DDL script will keep running and rerunning, or the UNINSTALL NODE
will keep failing, until you drop the "visible" trigger, by hand, much
as you must have added it, by hand, earlier.

ERROR: Slony-I: Unable to disable triggers

This is the error that follows the "multiple triggers" problem.
------------------------------------------------------------------------------------------------------------

Should I have added the trigger to replication using slonik?  If so,
how, please?  I looked
on the slony.info web site but did not find the answer.

I am using slony1-1.2.21

Thanks,
Aleksey