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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logicalreplication
Дата
Msg-id 20170617012234.k373n2zh4vlnweit@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On 2017-06-16 21:08:44 -0400, Peter Eisentraut wrote:
> On 6/16/17 09:13, Константин Евтеев wrote:
> > 2017-06-13 5:57 GMT+03:00 Peter Eisentraut
> > <peter.eisentraut@2ndquadrant.com
> > <mailto:peter.eisentraut@2ndquadrant.com>>:
> > 
> >     I think this is all working correctly and as intended.
> > 
> > But then, why data copy for init logical replication fires statement
> > trigger. May be it is also not nedeed?
> > Or this feature needs to be mentioned in documentation?
> 
> I don't know.  Hackers?
> 
> The issue is that the logical replication initial data copy fires a
> statement trigger for INSERT, because it's implemented as a COPY internally.
> 
> By contrast, the normal apply worker does not fire any statement
> triggers (because they are not "statements").
> 
> We could adjust one or the other or leave it as is.

Leave it as is.

- Andres



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Getting server crash on Windows when using ICUcollation