Postgres Pro
Downloads
Home   >   mailing lists

RE: Repeatable reads - Mailing list pgsql-sql

From Mikheev, Vadim
Subject RE: Repeatable reads
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018CCD@SECTORBASE1
Whole thread Raw
In response to Repeatable reads  ("Michael Richards" <michael@fastmail.ca>)
List pgsql-sql
Tree view 
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
>

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Three Unrelated Questions
Next
From: Forest Wilkinson
Date:
Subject: Re: SQL functions not locking properly?