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

From Peter Eisentraut
Subject Re: [BUGS] BUG #14699: Statement trigger and logical replication
Date
Msg-id cf941ded-1f8e-08b0-d864-e83c1768f27b@2ndquadrant.com
Whole thread Raw
In response to [BUGS] BUG #14699: Statement trigger and logical replication  (konst583@gmail.com)
Responses Re: [BUGS] BUG #14699: Statement trigger and logical replication
List pgsql-bugs
On 6/9/17 12:01, konst583@gmail.com wrote:
> I have found a bug in logical replication and statement trigger on
> subscriber.
> Statement trigger works on initialisation table statement.
> But then it doesn't work.

The inserting of rows from the stream is not a "statement".  Therefore,
statement triggers are not fired for that.

The initial data copy is implemented as a COPY command, which is why
statement triggers fire for that.

I think this is all working correctly and as intended.

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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] BUG #14703: documentation bug:
Next
From: naveen7eceindia@gmail.com
Date:
Subject: [BUGS] BUG #14704: How to create unique index with a case statement?