[Pgpool-general] pgpool-II 2.1 beta1 testing results

[Tatsuo Ishii]

[Description]

If 

reset_query_list = 'DISCARD ALL'

is specified and client does not close a transaction before exiting,
a PostgreSQL error occurs since DISCARD ALL is not allowed in an open
transaction.

[Workaround]

Add 'ABORT' to reset_query_list. i.e.

reset_query_list = 'ABORT; DISCARD ALL'

[TODO]

If DISCARD ALL is specified in the reset_query_list and transaction is
not closed when client disconnects, automatically issue ABORT before
issue DISCARD ALL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan