Skip site navigation (1) Skip section navigation (2)

Re: isolation level

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Jaime Casanova <el_vigia_ec(at)hotmail(dot)com>,pgsql-sql(at)postgresql(dot)org
Subject: Re: isolation level
Date: 2004-05-14 05:26:09
Message-ID: 87r7tnpojy.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-sql
Bruno Wolff III <bruno(at)wolff(dot)to> writes:

> On Thu, May 13, 2004 at 18:13:23 +0000,
>   Jaime Casanova <el_vigia_ec(at)hotmail(dot)com> wrote:
> > Hi all, is there a way to set the isolation level  to something like the 
> > sql standard dirty read.
> 
> No. There will be a way to use the standard name in a SET command, but
> you will actaully get READ COMMITTED isolation (which is the next step up).

I wonder how hard this would be to implement. It doesn't seem like it should
be very hard.

It would be very convenient for debugging and for checking on the progress of
large batch updates or loads.

-- 
greg


In response to

pgsql-sql by date

Next:From: Greg StarkDate: 2004-05-14 05:40:26
Subject: Re: Multiple outer join on same table
Previous:From: Stephan SzaboDate: 2004-05-14 05:24:06
Subject: Re: a wierd query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group