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 |
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 (?) |