Behaviour of triggers on replicated and non replicated tables

Поиск
Список
Период
Сортировка
От Luiz K. Matsumura
Тема Behaviour of triggers on replicated and non replicated tables
Дата
Msg-id 4DF21A1B.3060101@planit.com.br
обсуждение исходный текст
Ответы Re: Behaviour of triggers on replicated and non replicated tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
Hi,
I need help to know if the follow scenario is a expected behaviour, a
bug of postgres or a bug of slony:

Postgres v8.4.8
Slony-I v 2.0.5

I have table replicated with slony and that do some updates in another
table not replicated.

The trigger on replicated table was enabled on the slave database with
the command:

ALTER TABLE table1 ENABLE ALLWAYS TRIGGER trigger1;

And this trigger is working fine as expected.

The strange behaviour is that trigger do a update in another table not
replicated, let´s say table2, and
the triggers of this table is not fired.
A unexpected behaviour IMHO, if I do

ALTER TABLE table2 ENABLE ALWAYS TRIGGER trigger2;

Then the trigger2 is fired now when trigger1 do a update in table2.

My doubt is: since table2 is not replicated why they triggers dont fire
even by a update command in
a trigger of a replicated table ?


Best Regards,

Luiz K. Matsumura

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Denis de Bernardy
Дата:
Сообщение: expanded mode + wrapping in psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: expanded mode + wrapping in psql