Postgres Pro
Downloads
Home   >   mailing lists

Re: Another FK violation when referencing a multi-level partitionedtable - Mailing list pgsql-bugs

From Jehan-Guillaume de Rorthais
Subject Re: Another FK violation when referencing a multi-level partitionedtable
Date
Msg-id 20200210113439.0ea5f15e@firost
Whole thread Raw
In response to Re: Another FK violation when referencing a multi-level partitioned table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Another FK violation when referencing a multi-level partitionedtable
List pgsql-bugs
Tree view 
Hello,
On Sun, 09 Feb 2020 12:48:49 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > On 2020-Feb-06, Jehan-Guillaume de Rorthais wrote:  
> >> Please, find in attachment a proposal patch to fix this FK violation.  
> 
> > You fix looks correct to me, so pushed.  I took a minute to apply some
> > minor corrections to the comments, too.  
> 
> FWIW, I think the test query is too smart for its own good:
> [...]

Indeed, thank you. Please find in attachment a patch making the test simpler.

Regards,
Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another FK violation when referencing a multi-level partitioned table
Next
From: Amit Kapila
Date:
Subject: Re: ERROR: subtransaction logged without previous top-level txn record