Re: Fix failing assert in deferred constraint trigger

On Fri, Sep 11, 2026 at 10:48 AM Fabrizio Mello
<fabrizio(at)planetscale(dot)com> wrote:
>
> On Wed, Sep 9, 2026 at 12:52 AM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> >
> > [...]
> >
> > BTW, WITH HOLD cursor seems to be able to cause the same issue:
> >
> > CREATE FUNCTION hoge() RETURNS integer
> > LANGUAGE plpgsql VOLATILE AS $$
> > BEGIN
> > PERFORM 1 / 0;
> > RETURN 0;
> > EXCEPTION WHEN division_by_zero THEN
> > RETURN 1;
> > END;
> > $$;
> >
> > BEGIN;
> > DECLARE c NO SCROLL CURSOR WITH HOLD FOR SELECT hoge();
> > COMMIT;
> >
>
> Having a look into it thanks!
>

Confirmed that the patch works fine also with "WITH HOLD" cursor.

Regards,

--
Fabrízio Mello
PlanetScale Postgres Core Team