pgbouncer icon indicating copy to clipboard operation
pgbouncer copied to clipboard

Published 20 hours ago • verified publisher icon pgbouncer

Protocol level prepared statements

Open greenboxal opened this issue 8 years ago • 4 comments
trafficstars

Is anyone working on that? If not, I'm interested in developing this feature.

greenboxal avatar Oct 22 '17 00:10 greenboxal

I'm not sure what you hope to get here. In the referenced bug it was discussed that transaction pool mode doesn't work with prepared statements but session pool mode does.

petere avatar Dec 06 '17 15:12 petere

Postgres protocol has enough information so that pgbouncer can support prepared statements. I just wanted to check if someone is already working on that feature.

If not, I'll develop it and send a PR.

greenboxal avatar Dec 06 '17 17:12 greenboxal

Am I right to presume Pgbouncer does not support Extended Query Protocol in Transaction Pool Mode due to the lack of this feature ?

kien-truong avatar Jan 21 '22 03:01 kien-truong

Extended query is supported in all pooling modes.

petere avatar Jan 21 '22 09:01 petere

Closing this because protocol-level prepared statements was merged in #845 and is now released in PgBouncer 1.21.0

JelteF avatar Nov 03 '23 11:11 JelteF