Hi chaps,

When a table on a slave is put into slony replication, what happens to the driggers on the table?

E.g I have a table "replicated_users" on each server and the table has a trigger "replicate_users". Once in replication I can no longer asee the "replicate_users" trigger on the slave, I presume it is just dropped? At the moment I'm just recreating the trigger after putting the table into replication, however I wondered if this could cause any problems?

I guess it would be better to create a slonik script to create the tables with execute_script, then subscribe them, and then add int he triggers with execute_script?



      ___________________________________________________________ 
Yahoo! For Good helps you make a difference  

http://uk.promotions.yahoo.com/forgood/