Hiya,
If its any help, I've tried this and didn't have much luck with the ODBC
options - also had problems with getting to to put NOT NULL constraints on
tables too. Didn't seem to make a difference with ODBC 2.0 or 3.0. What I
ended up doing was picking "Interbase" as my target server, purely because
(by a process of elimination!) I could get this to generate SQL that worked
with Postgres, and then using the Forward Engineer-Generate report option
(with some of the options like create domian turned off). This made a
script which I could then run against my Postgres database.
Tamsin
-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Carlos Felipe Zirbes
Sent: 14 August 2000 13:55
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostGres and ERwin
Hi.
Has anyone ever used erwin to connect to postgres?
I have been trying to use erwin 3.5.2 sp2 to connect to pgsql via the latest
odbc driver available and can't get erwin do create PK and FK constraint
correctly. What odbc version should I use? 2.0 or 3.0?
Any help or report about this matter is welcome.
Thanks in advance,
Zirbes