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

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication
Дата
Msg-id CAHE3wghmzCJ8hD0DKfAJdts9iGfSazBOa+CGY=heBZVKzauN6A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logicalreplication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
2017-06-16 22:08 GMT-03:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:

The issue is that the logical replication initial data copy fires a
statement trigger for INSERT, because it's implemented as a COPY internally.

We should document such behavior. AFAICS we discuss later if we should provide an option to fire statement triggers during initial copy.
 
By contrast, the normal apply worker does not fire any statement
triggers (because they are not "statements").

+1.
 
We could adjust one or the other or leave it as is.

Let's leave it as is. At least until 11.


--
   Euler Taveira                                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: Erik Rijkers
Дата:
Сообщение: Re: [HACKERS] logical replication - still unstable after all thesemonths
Следующее
От: Ashutosh Sharma
Дата:
Сообщение: Re: [HACKERS] Getting server crash on Windows when using ICU collation