RE: Closest SQL dialect to PostgreSQL for ERwin?

Sorry for answering a really old message...
Since I worked on all of these databases I could
not resist.

Miro-Montage-Illustra was the product that was derived
directly from postgres. It was bought by informix and
re-implemented in version 9.* of the informix server.

ingres was based on a much much much earlier version of
the university code.

The illustra code base is very recognizably postgres.

The dialect of SQL is unique to the ORDBMS crowd. You
can get a pure relational schema from ERWin that will
work, but you have to manipulate it afterwards if you
use any non-SQL92 features. Boy, wouldn't I love to
have a good ORDBMS schema tool... Too bad informix's isn't
good.

elein
ex-ingres, ex-miro/illustra, ex-informix
currently postgreSQL database architect
elein(at)nextbus(dot)com

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Alex Pilosov
Sent: Thursday, November 30, 2000 10:57 PM
To: Ed Loehr
Cc: pggeneral
Subject: Re: [GENERAL] Closest SQL dialect to PostgreSQL for ERwin?

Genealogicaley, Ingres would indeed be closest to pgsql (both are direct
descendants of University Ingres).

Probably a nicer thing would be for ERwin to have SQL-92 dialect, but
since nobody other than postgres even tried to comply to it, ERWin doesn't
support it ;)

On Thu, 30 Nov 2000, Ed Loehr wrote:

> I'm using ERwin to reverse engineer an ER diagram from PostgreSQL SQL
> scripts (via pg_dump). ERwin does not officially support PostgreSQL's
> flavor of SQL, though having it read PostgreSQL scripts as Ingres scripts
> seems to work ok.
>
> Is there another well-known RDBMS vendor (Informix?) whose dialect and
> SQL idiosyncrasies (sp?) are closer to PostgreSQL's SQL than Ingres?
> ERwin supports most of the big RDBMS names (Pg is the only one I noticed
> missing), and I don't know much about the various dialect differences.
>
> Regards,
> Ed Loehr
>
>