Postgres Pro
Downloads
Home   >   mailing lists

Thread: Referencial Link with ODBC

Referencial Link with ODBC

From
Elielson Fontanezi
Date:
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

 

Re: Referencial Link with ODBC

From
Craig Addleman
Date:
I have the same problem with ERwin, although I'm not creating databases with it, only ERDs. All the end developers using our db rely on ERDs for their work. Can anyone provide a workaround?
 
Many thanks,
 
Craig Addleman
DBA
ShareChive, LLC
San Francisco
-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.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

 

Re: Referencial Link with ODBC

From
"Hiroshi Inoue"
Date:
Unfortunately I don't know what ERwin requires.
If you are using the ODBC2.50 driver, ODBC3.0 driver may be a little better.
Please try the ODBC3.0 driver at http://w2422.nsk.ne.jp/~inoue/ .
Note that it's a different driver and so you have to register the driver
first and create new DSNs for the driver.
 
regards,
Hiroshi Inoue
-----Original Message-----
From: Craig Addleman

I have the same problem with ERwin, although I'm not creating databases with it, only ERDs. All the end developers using our db rely on ERDs for their work. Can anyone provide a workaround?
 
Many thanks,
 
Craig Addleman
DBA
ShareChive, LLC
San Francisco
-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.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

 

Re: Referencial Link with ODBC

From
"Tambet Matiisen"
Date:
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@prodam.sp.gov.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

Re: Referencial Link with ODBC

From
Craig Addleman
Date:
I finally following up on this, Hiroshi. The problem is that although foreign keys are detected by ERWin, cascade options for foreign keys are not. Same for MS Visio. (I will send you an image off-list so you have a better idea of what I mean.) As a DBA for a company about to sign contracts for several projects (finally!), I am not looking forward to managing cascade_on_delete/update/insert options for every table in several schemas in a production and development databases without some kind of GUI tool. (Hey, how do you other Postgres dba's do it? Someone mentioned Rational Rose, but I haven't tried that as the company work for can only afford one pricey software tool.)
We're currently running PostgreSQL 7.2.1, sood to upgrade to 7.3, using ODBC3.0.
With ERWin a very popular, perhaps the leading, program among Oracle dba's for generating ERD's it would be helpful to have Postgres interface with them as well as Oracle or SQLServer does.
Being a dba as opposed to a driver developer, I really don't know what ERWin or Visio need to see what FK cascades are doing, but perhaps this information can be gotten from Computer Associates; URL (disguised so Outlook doesn't break it): xxx3.ca.com/Solutions/Product.asp?ID=260.
Any chance this could find a place on your list of TO DOs?
 
 
Craig Addleman
DBA
ShareChive, LLC
San Francisco
 
-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
Sent: Monday, November 11, 2002 10:08 PM
To: Craig Addleman
Cc: pgsql-obc
Subject: RE: [ODBC] Referencial Link with ODBC

Unfortunately I don't know what ERwin requires.
If you are using the ODBC2.50 driver, ODBC3.0 driver may be a little better.
Please try the ODBC3.0 driver at http://w2422.nsk.ne.jp/~inoue/ .
Note that it's a different driver and so you have to register the driver
first and create new DSNs for the driver.
 
regards,
Hiroshi Inoue
-----Original Message-----
From: Craig Addleman

I have the same problem with ERwin, although I'm not creating databases with it, only ERDs. All the end developers using our db rely on ERDs for their work. Can anyone provide a workaround?
 
Many thanks,
 
Craig Addleman
DBA
ShareChive, LLC
San Francisco
-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.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

 

Re: Referencial Link with ODBC

From
Craig Addleman
Date:
I finally following up on this, Hiroshi. The problem is that although
foreign keys are detected by ERWin, cascade options for foreign keys are
not. Same for MS Visio. (I will send you an image off-list so you have a
better idea of what I mean.) As a DBA for a company about to sign contracts
for several projects (finally!), I am not looking forward to managing
cascade_on_delete/update/insert options for every table in several schemas
in a production and development databases without some kind of GUI tool.
(Hey, how do you other Postgres dba's do it? Someone mentioned Rational
Rose, but I haven't tried that as the company work for can only afford one
pricey software tool.)
We're currently running PostgreSQL 7.2.1, sood to upgrade to 7.3, using
ODBC3.0.
With ERWin a very popular, perhaps the leading, program among Oracle dba's
for generating ERD's it would be helpful to have Postgres interface with
them as well as Oracle or SQLServer does.
Being a dba as opposed to a driver developer, I really don't know what ERWin
or Visio need to see what FK cascades are doing, but perhaps this
information can be gotten from Computer Associates; URL (disguised so
Outlook doesn't break it): xxx3.ca.com/Solutions/Product.asp?ID=260.
Any chance this could find a place on your list of TO DOs?
Craig Addleman
DBA
ShareChive, LLC
San Francisco
-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
Sent: Monday, November 11, 2002 10:08 PM
To: Craig Addleman
Cc: pgsql-obc
Subject: RE: [ODBC] Referencial Link with ODBC

Unfortunately I don't know what ERwin requires.
If you are using the ODBC2.50 driver, ODBC3.0 driver may be a little better.

Please try the ODBC3.0 driver at <http://w2422.nsk.ne.jp/~inoue/> .
Note that it's a different driver and so you have to register the driver
first and create new DSNs for the driver.
regards,
Hiroshi Inoue
    -----Original Message-----
    From: Craig Addleman

    I have the same problem with ERwin, although I'm not creating
databases with it, only ERDs. All the end developers using our db rely on
ERDs for their work. Can anyone provide a workaround?
    Many thanks,
    Craig Addleman
    DBA
    ShareChive, LLC
    San Francisco
        -----Original Message-----
        From: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.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
<http://odbc.postgresql.org/ftpsite/odbc/versions/full/psqlodbc-07_02_0003.z
ip> 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