Re: alert clients when prepared statements are deallocated - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: alert clients when prepared statements are deallocated
Date
Msg-id CAOYmi+ndz7Dx5WdJu8zRPXLsA6U56jvcKnoT=ru2DhQtOKy=eA@mail.gmail.com
Whole thread
In response to Re: alert clients when prepared statements are deallocated  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
On Wed, Jun 3, 2026 at 2:17 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
> Hm.  So there's actually a pretty obvious problem here.  Say a user
> executes something like PQsendQuery(conn, "DISCARD ALL") and then tries to
> execute an lo_* function (modified to use prepared statements) prior to
> consuming the result.  In that case, the callback won't be called in time
> and the LO function will fail.

Are you allowed to call lo_*/PQfn() in the middle of an operation like
that? I.e. does it work today?

--Jacob



pgsql-hackers by date:

Previous
From: Andrey Chernyy
Date:
Subject: [PATCH] xml2: Fix stylesheet document leak in xslt_process()
Next
From: Richard Guo
Date:
Subject: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases