Thread: isolation level

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

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).

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