Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Paquier
Subject Re: Another FK violation when referencing a multi-level partitionedtable
Date
Msg-id 20200206080833.GL23913@paquier.xyz
Whole thread Raw
In response to Another FK violation when referencing a multi-level partitionedtable  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Responses Re: Another FK violation when referencing a multi-level partitionedtable  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Tree view 
On Thu, Feb 06, 2020 at 12:49:48AM +0100, Jehan-Guillaume de Rorthais wrote:
> Please, find in attachment a proposal patch to fix this FK violation.

Indeed.  I would have expected the deletion of the referenced rows to
happen as in your test.  At quick glance, your fix looks right, but I
need to study more this code.  Alvaro, would you like to weigh in as
the author of f56f8f8?
--
Michael
Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #16242: convert_tuple_* not handling missing values correctly
Next
From: PG Bug reporting form
Date:
Subject: BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available