[php-src] Issue #12940: [PDO/PGSQL] Add an option that disables sending DEALLOCATE
| From: | lucaspouzac | Date: | Tue, 12 Dec 2023 10:01:51 +0000 |
| Subject: | [php-src] Issue #12940: [PDO/PGSQL] Add an option that disables sending DEALLOCATE | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-246042@lists.php.net to get a copy of this message | ||
Issue: https://github.com/php/php-src/issues/12940
Author: lucaspouzac
### Description
As explained on [pgbouncer issue #991](https://github.com/pgbouncer/pgbouncer/issues/991), it's
not possible to use prepared statement cache of pgbouncer with PDO, because PDO send **DEALLOCATE
pdo_stmt_..**
Adding an option to disable DEALLOCATE sending would allow pgbouncer to be used in transaction mode
with its prepared statement cache.
May be the opportunity to use
[PQclosePrepared](https://www.postgresql.org/docs/devel/libpq-exec.html#LIBPQ-PQCLOSEPREPARED)
instead of DEALLOCATE. (Note: This will only be released in libpq 17) ?