Re: Eliminating SPI from RI triggers - take 2

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Eliminating SPI from RI triggers - take 2
Date: 2022-10-11 07:37:13
Message-ID: CA+HiwqFttXFSOR-5c=rk-oh9VCyvyKHjb2RznnH2o2-2BQRykQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Oct 7, 2022 at 7:17 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Fri, Oct 7, 2022 at 19:15 Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
>> On 2022-Oct-07, Amit Langote wrote:
>> > > Thanks for the heads up. Hmm, this I am not sure how to reproduce on
>> > > my own, so I am currently left with second-guessing what may be going
>> > > wrong on 32 bit machines with whichever of the 4 patches.
>> > >
>> > > For now, I'll just post 0001, which I am claiming has no semantic
>> > > changes (proof pending), to rule out that that one's responsible.
>> >
>> > Nope, not 0001. Here's 0001+0002.

I had forgotten to actually attach anything with that email.

>> Please note that you can set up a github repository so that cirrus-ci
>> tests whatever patches you like, without having to post them to
>> pg-hackers. See src/tools/ci/README, it takes three minutes if you
>> already have the account and repository.
>
> Ah, that’s right. Will do so, thanks for the suggestion.

I'm waiting to hear from GitHub Support to resolve an error I'm facing
trying to add Cirrus CI to my account.

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

Attachment Content-Type Size
v6-0001-Avoid-using-SPI-in-RI-trigger-functions.patch application/x-patch 33.6 KB
v6-0002-Avoid-using-an-SQL-query-for-some-RI-checks.patch application/x-patch 34.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-10-11 07:59:58 Re: future of serial and identity columns
Previous Message Amit Kapila 2022-10-11 07:36:55 Re: Add common function ReplicationOriginName.