Re: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition)

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Zhihong Yu <zyu(at)yugabyte(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition)
Date: 2022-10-03 12:47:57
Message-ID: 20221003144757.1d2b86da@karst
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 30 Sep 2022 16:11:09 -0700
Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:

> On Fri, Sep 30, 2022 at 3:30 PM Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
> wrote:
...
>
> + * Self-Foreign keys are ignored as the index was preliminary
> created
>
> preliminary created -> primarily created

Thank you! This is fixed and rebased on current master branch in patches
attached.

Regards,

Attachment Content-Type Size
0001-v2-Fix-bug-between-constraint-parenting-and-self-FK.patch text/x-patch 2.0 KB
0002-v2-Fix-bug-where-a-self-FK-was-cloned-twice-on-partitio.patch text/x-patch 2.0 KB
0003-v2-Add-regression-tests-about-self-FK-with-partitions.patch text/x-patch 4.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ranier Vilela 2022-10-03 12:49:55 Re: PostgreSQL 15 GA release date
Previous Message Julien Rouhaud 2022-10-03 12:40:13 Re: PostgreSQL 15 GA release date