On Fri, Apr 21, 2017 at 5:08 AM, Egor Rogov <e.ro...@postgrespro.ru> wrote: > Hello, > It seams that tiggers don't fire on subscriber's tables during logical > replication. Is it a bug?
Reading the documentation (which is TBH a bit hard to follow) it appears that it is expected behavior. https://www.postgresql.org/docs/devel/static/logical-replication-architecture.html#logical-replication-snapshot states: "The apply process on the subscriber database always runs with session_replication_role set to replica, which produces the usual effects on triggers and constraints." https://www.postgresql.org/docs/devel/static/sql-altertable.html states: "The trigger firing mechanism is also affected by the configuration variable session_replication_role. Simply enabled triggers will fire when the replication role is “origin” (the default) or “local”." merlin -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers