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

Reply via email to