Re: simplifying foreign key/RI checks

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: simplifying foreign key/RI checks
Date: 2021-04-02 12:46:18
Message-ID: CA+HiwqGW7rB4tiNZWH1Sry__WwNfTdveyzrNKs0-t92f1SmpKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Mar 20, 2021 at 10:21 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> Updated patches attached. Sorry about the delay.

Rebased over the recent DETACH PARTITION CONCURRENTLY work.
Apparently, ri_ReferencedKeyExists() was using the wrong snapshot.

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

Attachment Content-Type Size
v8-0001-Export-get_partition_for_tuple.patch application/octet-stream 2.8 KB
v8-0002-Avoid-using-SPI-for-some-RI-checks.patch application/octet-stream 33.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Isaac Morland 2021-04-02 13:09:04 Re: policies with security definer option for allowing inline optimization
Previous Message Alvaro Herrera 2021-04-02 12:36:50 Re: libpq debug log