release should reset state of connection

brianc / node-pg-pool

A connection pool for node-postgres

MIT License

180 stars 64 forks source link

Open daurnimator opened 5 years ago

daurnimator commented 5 years ago

When a connection is released back to the pool, the connection should be reset to a clean state. This should probably be done by running

rollback;
discard all;

Alternatively/additionally, you should expose an event for a connection being added back to the pool. This would allow the query to be customisable.

Other pooling implementations have similar facilities, e.g. pgbouncer has the configuration parameter server_reset_query

charmander commented 5 years ago

(Formerly brianc/node-postgres#391 – from when the pool was part of pg)