[Pgpool-general] Simple question about pgpool behavior

[Christoph Handel]

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