Re: PostgreSQL x Oracle

On 9 Feb 2003 at 17:48, Ben-Nes Michael wrote:

> also I heard that you cant do transaction within transaction in postgres
> while in Oracle you can. ( im not sure if its true at all )

nope... "commit" in Oracle close ALL open transaction.

Just to put my 2 c.:

Postgres is by far easier in install. Without a skilled DBA you can't
even *think* in putting together a *working* Oracle installation.
Pl/SQL is far superior to pg/sql. But, in postgres you *can* use other
languages for SP.
"imp" and "exp" utility are far superior to pg_dump and pg_restore.
Oracle has the habit of thinking that *his* version of SQL is *the*
version of SQL (and it's the least similar to standards, IMHO).

Of course there are many other features that differs. The one I miss
more is the two-phase commit... (AKA transactions distributed
among databases)

Just my 0.02 Euros ;-)
bye!
--
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

  Fabrizio Ermini                 e-mail:
  P.za S. Allende, 8              hermooz@tin.it
  50063 Figline Valdarno (FI)     faermini@tin.it
  ITALY                           ICQ UIN: 24.64.37