Nevermind ... I RTFM ... echo "alter table mytable ENABLE REPLICA TRIGGER check_lockout;" | psql mydb -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Plugge, Joe R. Sent: Thursday, May 13, 2010 4:02 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
