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

From Peter Eisentraut
Subject Re: Comparison of PGSQL and DB2
Date
Msg-id 200403111959.46586.peter_e@gmx.net
Whole thread Raw
In response to Re: Comparison of PGSQL and DB2  (Josh Berkus <josh@postgresql.org>)
Responses Re: Comparison of PGSQL and DB2  (Robert Treat <xzilla@users.sourceforge.net>)
Re: Comparison of PGSQL and DB2  (Josh Berkus <josh@postgresql.org>)
List pgsql-advocacy
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.

Surely MVCC wasn't "invented for the Postgres Project"; otherwise Vadim
wouldn't have done so much copying from Oracle. ;-)

7.5 will support all four isolation levels.

> > Federated Database Support
> > (Ability to allow applications to access & perform JOIN operations
> > on
>
> multiple disparate databases.)
>
> This is a feature which we do not have because it violates the ANSI
> SQL Specification.

That would be news to me.


pgsql-advocacy by date:

Previous
From: Robert Treat
Date:
Subject: Re: Comparison of PGSQL and DB2
Next
From: Robert Treat
Date:
Subject: Re: Comparison of PGSQL and DB2