Re: Referencial Link with ODBC

The problem could be the SQL syntax ERWin tries to use. For example
Oracle Designer generates SQL to add several FK constraints in one ALTER
TABLE statement. Like this:

ALTER TABLE ARUANDED_GO2 ADD CONSTRAINT
GO_2_KAUBAGRUPP_FK FOREIGN KEY
(KAUBAGRUPP_KOOD2) REFERENCES KAUBAGRUPID
(KOOD2) ADD CONSTRAINT
GO_2_ARUANNE_FK FOREIGN KEY
(ARUANNE_ARUANNE_ID) REFERENCES ARUANDED
(ARUANNE_ID) ON DELETE CASCADE
/

PostgreSQL supports only one foreign key constraint in ALTER TABLE
statement. Rational Rose generates compatible SQL. In fact this is the
only reason we are using Rose for database design.

Tambet

-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF(at)prodam(dot)sp(dot)gov(dot)br]
Sent: Thursday, November 07, 2002 5:17 AM
To: pgsql-obc
Subject: [ODBC] Referencial Link with ODBC

Hi all!

I have installed the last psqlodbc psqlodbc-07_02_0003.zip driver.
I´ve saw that creating a new database with ERWin which required an
ODBC connection the referencial link (FK) are not created.
Is that as bug or a ODBC limitation?
..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.
Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493