Re: Comparison of PGSQL and DB2

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.