RE: Repeatable reads

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Michael Richards'" <michael(at)fastmail(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: RE: Repeatable reads
Date: 2000-09-19 18:06:44
Message-ID: 8F4C99C66D04D4118F580090272A7A23018CCD@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
>

Browse pgsql-sql by date

  From Date Subject
Next Message John McKown 2000-09-19 18:17:01 Re: sum of agreggates in one SELECT?
Previous Message Michael Richards 2000-09-19 17:48:23 Repeatable reads