Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Logical replication failing when foreign key present - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: [HACKERS] Logical replication failing when foreign key present
Date
Msg-id 33f8d9f3-c259-cd4b-712c-2c318a17274a@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Logical replication failing when foreign key present  (Thom Brown <thom@linux.com>)
Responses Re: [HACKERS] Logical replication failing when foreign key present  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On 22/01/17 18:50, Thom Brown wrote:
> Hi,
> 
> There's an issue which I haven't seen documented as expected
> behaviour, where replicating data to a table which has a foreign key
> results in a replication failure.  This produces the following log
> entries:
> 
> LOG:  starting logical replication worker for subscription "contacts_sub"
> LOG:  logical replication apply for subscription "contacts_sub" has started
> ERROR:  AfterTriggerSaveEvent() called outside of query
> LOG:  worker process: logical replication worker for subscription
> 16408 (PID 19201) exited with exit code 1
> 
> 

Hi, thanks for report.

Looks like I missed AfterTriggerBeginQuery/AfterTriggerEndQuery when
moving the executor stuff around. Attached should fix it.

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Protect syscache from bloating with negative cache entries
Next
From: Jim Nasby
Date:
Subject: Re: [HACKERS] [WIP]Vertical Clustered Index (columnar storeextension)