Thread: isolation level

isolation level

From
"Jaime Casanova"
Date:
Hi all, is there a way to set the isolation level  to something like the sql 
standard dirty read.

Thanx in advance,
Jaime Casanova

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail



Re: isolation level

From
Bruno Wolff III
Date:
On Thu, May 13, 2004 at 18:13:23 +0000, Jaime Casanova <el_vigia_ec@hotmail.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).


Re: isolation level

From
Greg Stark
Date:
Bruno Wolff III <bruno@wolff.to> writes:

> On Thu, May 13, 2004 at 18:13:23 +0000,
>   Jaime Casanova <el_vigia_ec@hotmail.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