Postgres Pro
Downloads
Home   >   mailing lists

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

From Euler Taveira
Subject Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication
Date
Msg-id CAHE3wghmzCJ8hD0DKfAJdts9iGfSazBOa+CGY=heBZVKzauN6A@mail.gmail.com
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 logicalreplication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Erik Rijkers
Date:
Subject: Re: [HACKERS] logical replication - still unstable after all thesemonths
Next
From: Ashutosh Sharma
Date:
Subject: Re: [HACKERS] Getting server crash on Windows when using ICU collation