Re: [HACKERS] Triggers and logical replication (10devel)

On 21.04.2017 16:29, Merlin Moncure wrote:
> On Fri, Apr 21, 2017 at 5:08 AM, Egor Rogov <e.rogov@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/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”."
Ah, ALTER TABLE ENABLE REPLICA TRIGGER is what I missed.
Thanks!

Regards,
Egor Rogov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company