[pgpool-general: 76] Re: unknown transaction isolation level:read uncommitted

[Tatsuo Ishii]

> I have pgpool-II 3.1.1 set up on front of two postgres 9.1 boxes, in
> streaming replication mode.
> 
> I have this error all over the pgpool logs:
> 
> pool_get_transaction_isolation: unknown transaction isolation level:read
> uncommitted
> 
> Now, my application does set up transaction isolation to READ
> UNCOMMITED, and postgres is setting it to READ COMMITED, but, why is
> pgpool complaining about it?

Pgpool asks current transaction isolation level at runtime. I know
PostgreSQL promotes READ UNCOMMITTED to READ COMMITTED and I thought
PostgreSQL returns READM COMMITTED in this case but apparently I was
wrong. Attached patch should fix the problem. Please try.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transaction.patch
Type: text/x-patch
Size: 1114 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20111209/ccd66b0c/attachment.bin>