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

[Mario Splivalo]

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! :)

	Mario