Postgres Pro
Downloads
Home   >   mailing lists

Thread: Repeatable reads

Repeatable reads

From
"Michael Richards"
Date:
It appears that postgres 7.0 does not support repeatable read for 
transaction isolation. Is this planned? If so, when?

-Michael
_________________________________________________________________    http://fastmail.ca/ - Fast Free Web Email for
Canadians

Re: Repeatable reads

From
Tom Lane
Date:
"Michael Richards" <michael@fastmail.ca> writes:
> It appears that postgres 7.0 does not support repeatable read for 
> transaction isolation. Is this planned? If so, when?

??  Maybe you need to do SET TRANSACTION ISOLATION LEVEL?
        regards, tom lane

RE: Repeatable reads

From
"Mikheev, Vadim"
Date:
Use

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

inside BEGIN/END block. Default is READ COMMITTED.

Vadim

> 
> It appears that postgres 7.0 does not support repeatable read for 
> transaction isolation. Is this planned? If so, when?
> 
> -Michael
> _________________________________________________________________
>      http://fastmail.ca/ - Fast Free Web Email for Canadians
>