On Mon, 15 Apr 2019, Sung Hsin Lei wrote: > Hello, > I'm able to create triggers on a non replicated DB. However, It does not seem > to work on > a replicated DB. I have a table A that is replicated to table B on another > machine. I want > to add a trigger in table B so that when a row is added in table B, it > notifies a program > that is listening. Unfortunately, the triggers that I implemented does not > seem to be raised > when the table is a replication of another. Is there any way around this?
See the "DISABLE/ENABLE [ REPLICA | ALWAYS ] TRIGGER" section of https://www.postgresql.org/docs/11/sql-altertable.html You want your triggers to fire ALWAYS or only on the replica. Steve > > > Thanks. > > Sung Hsin > > _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general