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:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2021-01-18 12:39:48 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎  2021-01-18 17:48:47 from Zhihong Yu <zyu(at)yugabyte(dot)com>   2021-01-19 02:45:29 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎    2021-01-19 03:01:47 from Zhihong Yu <zyu(at)yugabyte(dot)com>     2021-01-19 07:46:30 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-01-19 03:11:50 from japin <japinli(at)hotmail(dot)com>     2021-01-19 05:56:02 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>      2021-01-19 06:26:09 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-01-19 06:46:28 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>     2021-01-19 07:44:56 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎      2021-01-19 17:55:10 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>      2021-01-22 06:22:07 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>       2021-01-23 07:10:24 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎        2021-01-23 17:53:59 from Zhihong Yu <zyu(at)yugabyte(dot)com>         2021-01-24 02:26:24 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>          2021-01-24 11:51:39 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎           2021-01-25 00:24:00 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>            2021-01-25 09:19:56 from Amit Langote <amitlangote09(at)gmail(dot)com>             2021-01-26 23:51:40 from Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>              2021-01-27 06:10:53 from Amit Langote <amitlangote09(at)gmail(dot)com>               2021-01-27 07:07:01 from Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>           2021-01-27 08:32:13 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>            2021-01-27 13:02:35 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎             2021-03-01 06:13:47 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>              2021-03-02 02:18:46 from Amit Langote <amitlangote09(at)gmail(dot)com>               2021-03-02 07:51:57 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>               2021-03-03 20:15:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2021-03-08 14:41:32 from Amit Langote <amitlangote09(at)gmail(dot)com>                 2021-03-16 13:37:56 from Amit Langote <amitlangote09(at)gmail(dot)com>                 2021-03-20 13:21:54 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                  2021-04-02 12:46:18 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                   2021-04-02 14:58:36 from Zhihong Yu <zyu(at)yugabyte(dot)com>                    2021-04-04 08:20:55 from Amit Langote <amitlangote09(at)gmail(dot)com>                     2021-07-05 16:56:16 from vignesh C <vignesh21(at)gmail(dot)com>                      2021-07-06 01:48:38 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                       2021-08-30 04:36:12 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                       2021-11-11 23:19:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2021-11-11 23:38:50 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                         2021-11-12 00:17:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2021-11-12 01:58:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2021-11-12 14:21:30 from Amit Langote <amitlangote09(at)gmail(dot)com>                          2021-11-12 14:31:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2021-11-12 03:18:27 from Amit Langote <amitlangote09(at)gmail(dot)com>                         2021-11-12 20:43:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2021-11-19 13:56:59 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                           2021-12-20 04:59:59 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                            2021-12-20 06:20:28 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                             2021-12-20 09:21:10 from Zhihong Yu <zyu(at)yugabyte(dot)com>                              2021-12-20 13:17:16 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                               2021-12-21 02:21:05 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                               2021-12-21 08:56:06 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                2022-01-18 06:30:52 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                 2022-03-14 08:33:26 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                  2022-03-14 09:32:25 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                   2022-03-22 04:01:06 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                    2022-04-07 01:05:36 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                     2022-04-11 07:47:46 from Amit Langote <amitlangote09(at)gmail(dot)com>                                      2022-05-02 11:50:10 from Amit Langote <amitlangote09(at)gmail(dot)com>                   2021-04-02 15:01:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                    2021-04-04 08:19:48 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎      2021-01-25 09:06:39 from Keisuke Kuroda <keisuke(dot)kuroda(dot)3862(at)gmail(dot)com>       2021-01-25 10:01:44 from Amit Langote <amitlangote09(at)gmail(dot)com>        2021-01-25 11:04:41 from Amit Langote <amitlangote09(at)gmail(dot)com>        2021-01-27 07:58:44 from Keisuke Kuroda <keisuke(dot)kuroda(dot)3862(at)gmail(dot)com>  2021-01-18 18:00:38 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>   2021-01-19 02:08:48 from Amit Langote <amitlangote09(at)gmail(dot)com>    2021-01-19 04:17:16 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Lists:	pgsql-hackers

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

• Re: simplifying foreign key/RI checks at 2021-03-20 13:21:54 from Amit Langote

Responses

• Re: simplifying foreign key/RI checks at 2021-04-02 14:58:36 from Zhihong Yu
• Re: simplifying foreign key/RI checks at 2021-04-02 15:01:02 from Alvaro Herrera

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