On Sun, Jun 26, 2011 at 5:29 AM, Steve Singer <[email protected]> wrote: > If you tried to add a trigger to a slave without using EXECUTE SCRIPT (in > 1.2) you might have corrupted your slave.
Yup, that's exactly what I did. I ended up dropping the trigger on the master, doing a complete data resync to the slave (re-created the replication set) and then added the trigger again (using psql, not slony, just because I did not know about SET ADD TRIGGER, thank you.) > This is all different in 2.0, I would recommend also looking at how 2.0 > deals with this stuff and start planning an upgrade. Yup, will do, thanks very much, Steve and Martijn! Cheers, -at _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
