Re: find out default transaction isolation level

Niall Litchfield wrote:
> the default level in all versions (including 9.2) is read committed. This
> can only be changed on a per transaction or per session basis. What problems
> are you having that you attribute to a difference in isolation level?

so it seems to be the other way round. if i understood 'read committed' correctly, it meens that you can only read data which is comitted. now i was able to read data which was not yet commited, although i was connecting using another connection. bis this might be the problem. because i'm using PHP4 to connect my database & it tries to share the connections when you do not explicitly say: new connection.

maybe we relied on this feature & now had problems because in one case we used new connections to work without autocommmit.

-- 
mac

real email-adress: mac clondiag com