Re: Comparison of PGSQL and DB2 - Mailing list pgsql-advocacy

From Bruno Wolff III
Subject Re: Comparison of PGSQL and DB2
Date
Msg-id 20040311194702.GB25007@wolff.to
Whole thread Raw
In response to Re: Comparison of PGSQL and DB2  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Comparison of PGSQL and DB2
Re: Comparison of PGSQL and DB2
List pgsql-advocacy
On Thu, Mar 11, 2004 at 14:21:09 -0500,
  Robert Treat <xzilla@users.sourceforge.net> wrote:
> On Thu, 2004-03-11 at 13:59, Peter Eisentraut wrote:
> > Josh Berkus wrote:
> > > > Isolation Levels
> > > > (Support all four ANSI isolation levels (UR, CS, RS, RR).)
> > >
> > > I'm not sure about this one; I suspect that we do, however, since
> > > MVCC, invented for the Postgres Project, has become a standard for
> > > transaction isolation in the database industry.
> >
> > 7.5 will support all four isolation levels.
> >
>
> I wasn't aware of anyone doing work on this... do you have any more
> info?

My memory of past discussion on this is that you would be able to set all
4 transaction isolation levels in a command, but you would really get
the next level up for the two that we don't provide. This is OK since
since they get at least the transaction isolation safety they need.
The reason for doing this is portability.

pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Suggestion
Next
From: Gandalf
Date:
Subject: Re: Suggestion