Request a Demo
Home   >   mailing lists

Re: Eliminating SPI / SQL from some RI triggers - take 3 - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Eliminating SPI / SQL from some RI triggers - take 3
Date
Msg-id CA+HiwqHN0FQbyndiB4bApV8gEZ_tQBC_jr836HL=Mv_ZxK1+Pg@mail.gmail.com
Whole thread
In response to Re: Eliminating SPI / SQL from some RI triggers - take 3  (Sandro Santilli <strk@kbt.io>)
Responses Re: Eliminating SPI / SQL from some RI triggers - take 3
List pgsql-hackers
Tree view 
Hi Sandro,

On Thu, Apr 9, 2026 at 8:07 PM Sandro Santilli <strk@kbt.io> wrote:
> On Mon, Mar 02, 2026 at 01:34:41PM +0100, Tomas Vondra wrote:
> >
> > TBH I haven't noticed the memory context issue myself, I only noticed
> > because the builds with index prefetch started crashing.
>
> We're getting a crash in PostGIS too, since that commit was merged into
> the master branch, see https://trac.osgeo.org/postgis/ticket/6066
>
> The crash is triggered a C function using SPI.

Evan Montgomery-Recht posted a report of the same issue on this thread
a couple of days ago.

I have posted a patch to fix the issue, which I will commit tomorrow
after a bit more testing.

--
Thanks, Amit Langote

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Bug: WAIT FOR LSN crashes with assertion failure inside PL/pgSQL DO blocks and procedures
Next
From: Alexander Korotkov
Date:
Subject: Re: Bug: WAIT FOR LSN crashes with assertion failure inside PL/pgSQL DO blocks and procedures