Foreign keys lost when importing from PostgreSQL 10 into EA12 & EA14

[alex_ip]

G'day all...

I have a problem where foreign keys are not being imported into EA14 (or EA12, for that matter) from Postgres 10.

The tiny schema (dumped to SQL) is at https://www.dropbox.com/s/8y9t1x4yfpzilkw/vocabdb_201805161245.sql?dl=0 - I am using Postgres 10 and psqlODBC 10.02.00.00 under Windows 10. To replicate the problem, you can just try importing the schema into Database diagram in the "Basic  PostgreSQL Model" pattern.

The weird thing is that the foreign keys initially seemed to be working fine in EA12, but, at some point, many of them disappeared from the elements and the associations disappeared from the diagram on schema import. I have rebuilt the database, updated the ODBC driver, recreated the data source, started a new EA project and even upgraded from EA12 to EA14 to no avail. The foreign key definitions appear to be completely valid - the problem foreign keys in EA are the ones from three different tables (shown in the diagram without referential integrity) to the "term" table.

Does anyone have any ideas why this is happening? Is there a fix, or at least a work-around? I have had to abandon EA for the moment because I lose too much information on import.

Thanks in anticipation,

Alex