Re: [BUGS] BUG #14310: Triggers do not fire

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: [BUGS] BUG #14310: Triggers do not fire
Дата
Msg-id CAHnozTiuzyMGCJ4b8w=S5z9rmZzsS6-8z-5Z=w6L+fAu4D0oZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14310: Triggers do not fire  (Iurii Popov <iurii.i.popov@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [BUGS] BUG #14483: Prepared statement does not re-plan while it should
Следующее
От: marc@intershop.de
Дата:
Сообщение: [BUGS] BUG #14484: ERROR: missing chunk number 0 for toast value