[Pgpool-general] Simple question about pgpool behavior

Vitaly Ignatovich vitaly.ignatovich at gmail.com
Thu Feb 5 08:45:25 UTC 2009


I want to use pgpool in connection pool mode but not sure about tis behavior
in transaction block like this:

C1:client1 C2:client2

C1 opens connection
begin
select for update
C1 closes connection
C2 opens connection and gets the same connection as C1 had

Quesion: Will the C2 'inherit' transaction from C1? If yes, how to reset the
connection to cancel old tranasction and locks?

Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090205/e9d84ef7/attachment.html 


More information about the Pgpool-general mailing list