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
|
Список | 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 по дате отправления: