[Pgpool-general] Simple question about pgpool behavior

[Tatsuo Ishii]

> 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?

SQL statements defined in "reset_query_list" in pgpool.conf are called
when C1 closes the connection. The default values for
"reset_query_list" is 'ABORT; RESET ALL; SET SESSION AUTHORIZATION
DEFAULT', thus the lock will be automatically canceled unless you
remove ABORT from reset_query_list.
--
Tatsuo Ishii
SRA OSS, Inc. Japan