Re: [BUGS] BUG #14699: Statement trigger and logical replication

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [BUGS] BUG #14699: Statement trigger and logical replication
Дата
Msg-id cf941ded-1f8e-08b0-d864-e83c1768f27b@2ndquadrant.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14699: Statement trigger and logical replication  (konst583@gmail.com)
Ответы Re: [BUGS] BUG #14699: Statement trigger and logical replication  (Константин Евтеев <konst583@gmail.com>)
Список pgsql-bugs
On 6/9/17 12:01, konst583@gmail.com wrote:
> I have found a bug in logical replication and statement trigger on
> subscriber.
> Statement trigger works on initialisation table statement.
> But then it doesn't work.

The inserting of rows from the stream is not a "statement".  Therefore,
statement triggers are not fired for that.

The initial data copy is implemented as a COPY command, which is why
statement triggers fire for that.

I think this is all working correctly and as intended.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [BUGS] BUG #14703: documentation bug:
Следующее
От: naveen7eceindia@gmail.com
Дата:
Сообщение: [BUGS] BUG #14704: How to create unique index with a case statement?