On Fri, May 29, 2026 at 9:42 AM Nathan Bossart <[email protected]> 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
