On Fri, Sep 11, 2026 at 10:48 AM Fabrizio Mello
<[email protected]> wrote:
>
> On Wed, Sep 9, 2026 at 12:52 AM Fujii Masao <[email protected]> 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


Reply via email to