Re: [BUGS] BUG #14310: Triggers do not fire - Mailing list pgsql-bugs

From Willy-Bas Loos
Subject Re: [BUGS] BUG #14310: Triggers do not fire
Date
Msg-id CAHnozTiuzyMGCJ4b8w=S5z9rmZzsS6-8z-5Z=w6L+fAu4D0oZA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14310: Triggers do not fire  (Iurii Popov <iurii.i.popov@gmail.com>)
List pgsql-bugs
On Mon, Sep 26, 2016 at 4:29 PM, Iurii Popov <iurii.i.popov@gmail.com> wrote:
We also use Londiste 3 from Skytools. It seems londiste disables triggers via set session_replication_role = 'replica' and associated with the connection transactions do not fire triggers.

--
Iurii Popov

Hi, this comes a bit late, but it might be handy for future reference.
You can set tgenabled='A' for the trigger with an update query and it will make the trigger fire, regardless of the session_replication_role.
Specifics can be found in the docs: http://www.postgresql.org/docs/9.4/static/catalog-pg-trigger.html

Cheers,

--
Willy-Bas Loos

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [BUGS] BUG #14483: Prepared statement does not re-plan while it should
Next
From: marc@intershop.de
Date:
Subject: [BUGS] BUG #14484: ERROR: missing chunk number 0 for toast value