Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logicalreplication - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logicalreplication
Date
Msg-id 20170617012234.k373n2zh4vlnweit@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Thomas Munro <thomas.munro@enterprisedb.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Getting server crash on Windows when using ICUcollation