Re: Comparison of PGSQL and DB2

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 ]




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match