Book a Demo

Author Topic: Import DDL and Foreign Keys  (Read 3322 times)

brettonwoods

  • EA User
  • **
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Import DDL and Foreign Keys
« on: August 14, 2004, 10:05:39 am »
Hi All,

At one time when I imported a Postgresql db EA created the tables and FK associations.

Now only tables are imported with the FK's stereotyped incorrectly as indexes. Is there anything I can do correct this?

I'm using EA 4.00.701, Postgresql ODBC driver 7.02.00.05

Thanks
Tom

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import DDL and Foreign Keys
« Reply #1 on: August 15, 2004, 03:09:32 pm »
Try build 734.

brettonwoods

  • EA User
  • **
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Re: Import DDL and Foreign Keys
« Reply #2 on: August 16, 2004, 12:52:09 pm »
It worked but...
Every FK triggered an alert that required a user response:

DAO.Recordset [3022] "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

Tom



hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import DDL and Foreign Keys
« Reply #3 on: August 16, 2004, 03:24:24 pm »
Build 735 (out in a week or 2) will fix that error.