Re: Fix failing assert in deferred constraint trigger

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!

--
Fabrízio Mello
PlanetScale Postgres Core Team