I’m using the Trial version (18.104.22.168) to reverse engineer from a Postgres 8.4 database.
However virtually none of the referential constraints are coming through. The only ones I do get are where the RI is against a unique index rather than the primary key index.
The reverse engineer does alert to “no parent item (key or index) has been found during foreign key creation”. Looking on the entity properties, the Keys tab has one “Key1” item marked as a PK but double clicking it shows no attributes are selected.
In short, somehow it isn’t picking up the primary key index.
I can see it in the SQL pane in pgAdmin [eg CONSTRAINT xx_pk PRIMARY KEY (xx_id)] and I can see that the index is used for a query.
Is it likely to be a privilege issue ? Known bug in either Postgres (eg it isn’t showing in a catalog view) or TDM ?
Can anyone say what query TDM is issuing to determine the primary key / index / columns ?