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

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Another FK violation when referencing a multi-level partitioned table
Date: 2020-02-10 10:34:39
Message-ID: 20200210113439.0ea5f15e@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,
On Sun, 09 Feb 2020 12:48:49 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Alvaro Herrera <alvherre(at)2ndquadrant(dot)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 Content-Type Size
0001-Simpler-FK-regression-test-with-mult-level-partition.patch text/x-patch 1.8 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2020-02-10 11:03:31 Re: ERROR: subtransaction logged without previous top-level txn record
Previous Message Tom Lane 2020-02-09 17:48:49 Re: Another FK violation when referencing a multi-level partitioned table