On Thu, Feb 05, 2009 at 09:45:25AM +0100, Vitaly Ignatovich wrote: > 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?
see reset_query_list (http://pgpool.projects.postgresql.org/) Specifies the SQL commands sent to the backend when exitting a session to reset the connection. Multiple commands can be specified by delimitting each by ";". Default is the following, but can be changed to suit your system. reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' Greetings Christoph _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
