Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logicalreplication
Date
Msg-id 14dceb54-f510-8c4e-b3b7-412b2fd566e9@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] [BUGS] BUG #14699: Statement trigger and logical replication  (Euler Taveira <euler@timbira.com.br>)
List pgsql-hackers
Tree view 
On 6/17/17 08:29, Euler Taveira wrote:
> 2017-06-16 22:08 GMT-03:00 Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com
> <mailto: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.

I have added the documentation.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [HACKERS] subscription worker signalling wal writer too much
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Get stuck when dropping a subscription duringsynchronizing table