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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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