On Thu, May 13, 2010 at 5:11 PM, Plugge, Joe R. <jrplu...@west.com> wrote:
> Nevermind ... I RTFM ... > > echo "alter table mytable ENABLE REPLICA TRIGGER check_lockout;" | psql > mydb > This is not good idea. Always run DDL script using Slony execute script. http://www.slony.info/documentation/ddlchanges.html > > -----Original Message----- > From: pgsql-admin-ow...@postgresql.org [mailto: > pgsql-admin-ow...@postgresql.org] On Behalf Of Plugge, Joe R. > Sent: Thursday, May 13, 2010 4:02 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Slony-I - Update trigger on a replicated table > > Anyone know if it is possible to create an update trigger on the > destination side of a replicated table in Slony-I and have the replication > itself cause the trigger to fire? I was able to add the trigger but when run > the test transaction through, it does not seem to be firing. It works on > the non-replicated version of the solution. > > Running postgres 8.4.1 and Slony-I 2.0.3 > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
