Devart Forums

Hi

Using dotConnect PostgreSQL v2009 vol 3.4

We seem to have an issue when renaming a foreign key name within the new integrated VS Entity Designer. We have a table named TblTransactCrossRef
with 2 foreign keys named TblTransaction and TblTransaction1.
We can successfully rename TblTransaction to LinkedTransaction but when trying to rename TblTransaction1 to TblTransaction the model tells us this name is already in use. We have tried a number of ways to overcome this but to no result. We were able to successfully rename these FK in the previous versions of dotConnect.

Any ideas?
Many thanks

Stephen

Stephen Wright
Cognito Software Limited

This issue seems to be associated with the referential constraint (Foreign Key) also present in the model in VS 2010 models.
Could you please send us (support * devart * com, subject "Duplicate FK Name") the model and the script of the tables taking part in the associations?