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

[Tatsuo Ishii]

> On 12/09/2011 01:34 AM, Tatsuo Ishii wrote:
>>> 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.
> 
> Eh, my procmail rules put this new list emails to bogus folders so I
> caught this only now.
> 
> Yes, it is working ok now, thank you! :)

Glad to hear that!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp