On Sun, Jun 26, 2011 at 5:29 AM, Steve Singer <ssinger_pg at sympatico.ca> 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