> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
