Re: simplifying foreign key/RI checks

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Zhihong Yu <zyu(at)yugabyte(dot)com>
Cc: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: simplifying foreign key/RI checks
Date: 2021-12-20 13:17:16
Message-ID: CA+HiwqGAPODbXk78=8B9msp+xj0xKpv29gbtHQie3rq-MSn3dA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 20, 2021 at 6:19 PM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> On Sun, Dec 19, 2021 at 10:20 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>>
>> On Mon, Dec 20, 2021 at 2:00 PM Corey Huinker <corey(dot)huinker(at)gmail(dot)com> wrote:
>> > Sorry for the delay. This patch no longer applies, it has some conflict with d6f96ed94e73052f99a2e545ed17a8b2fdc1fb8a
>>
>> Thanks Corey for the heads up. Rebased with some cosmetic adjustments.
>>
> Hi,
>
> + Assert(partidx < 0 || partidx < partdesc->nparts);
> + partoid = partdesc->oids[partidx];
>
> If partidx < 0, do we still need to fill out partoid and is_leaf ? It seems we can return early based on (should call table_close(rel) first):
>
> + /* No partition found. */
> + if (partidx < 0)
> + return NULL;

Good catch, thanks. Patch updated.

--
Amit Langote
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
v12-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch application/octet-stream 6.5 KB
v12-0002-Avoid-using-SPI-for-some-RI-checks.patch application/octet-stream 39.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2021-12-20 13:31:17 [PATCH] pg_stat_toast v0.3
Previous Message Amit Langote 2021-12-20 13:10:30 Re: a misbehavior of partition row movement (?)