Thread: Re: Comparison of PGSQL and DB2

On Thu, 11 Mar 2004, Rod Taylor wrote:

> > are we just
> > pretending to set the level in 7.5 but still using the next level higher?
>
> I believe Peter found verbiage in the spec that said to do exactly that.
> Something about the isolation level being the minimum requirement, and
> better than that was acceptable.

Oh, good.  So we're gonna support:

set TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

by just setting the level to set READ COMMITTED when we get the request.

Will the transaction isolation level var SAY we're in READ UNCOMMITTED
when it's set, or will it show READ COMMITTED?  Just wondering.

On Thu, 2004-03-11 at 17:01, scott.marlowe wrote:
> On Thu, 11 Mar 2004, Rod Taylor wrote:
>
> > > are we just
> > > pretending to set the level in 7.5 but still using the next level higher?
> >
> > I believe Peter found verbiage in the spec that said to do exactly that.
> > Something about the isolation level being the minimum requirement, and
> > better than that was acceptable.
>
> Oh, good.  So we're gonna support:

It's not a gonna, what exists in -TIP is what you get.

Peter did this very shortly after 7.5 development started.

START TRANSACTION
    [ ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE
READ | SERIALIZABLE } ]
    [ READ WRITE | READ ONLY ]