Thread

Re: future of PQfn()

Jacob Champion <jacob.champion@enterprisedb.com> — 2026-05-29T17:04:16Z

On Fri, May 29, 2026 at 9:42 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
> Along these lines, I did consider "pinning" statements or even having
> "built-in" ones for libpq.  I didn't like the "pinning" idea because that
> seemed problematic for connection poolers.

Right -- whether a general context, or multiplexed streams, or
explicit pins, proxies would have to be intimately aware of them. They
can then layer their own on top, or make sure different client
requests don't conflict, or release them on client disconnection...

> And the "built-in" idea seemed
> too libpq-centric for what I'd argue is a general problem.  The other ideas
> involved guessing at what's happening based on the queries or somehow
> trying to handle failures due to missing/wrong prepared statements, none of
> which felt viable.

Agreed. (Although, for that last point, I wondered whether we could
make this idempotent somehow. I think the answer is "not worth it".)

--Jacob