Re: Another FK violation when referencing a multi-level partitioned table

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Another FK violation when referencing a multi-level partitioned table
Date: 2020-02-06 08:08:33
Message-ID: 20200206080833.GL23913@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

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