Page 1 of 1

INT4 != int4

Posted: Thu 13 Jan 2011 20:44
by seser
After I have installled entitiy developer 3.0.65 (which is released on 2011-01-12) every time update my model from database (postgresql), all integer fields seems as changed.

is there any solution for that problem.

Posted: Fri 14 Jan 2011 13:29
by AndreyR
I have performed a couple of tests (both Devart Entity model and Devart LinqConnect model) using a simple table and succeeded. The table was not shown as modified.
Could you please send us (support * devart * com, subject "PostgreSQL Int4 issue") the model you are using and the script of the initial tables?

Posted: Sat 15 Jan 2011 00:30
by seser
it was related to my regional settings (turkish). With english regional settings it works as expected.

Posted: Mon 17 Jan 2011 17:57
by AndreyR
Thank you for the additional information, we are investigating the situation with the Turkish locale. I will post here about the results of our investigation.

Posted: Mon 24 Jan 2011 14:32
by AndreyR
We have fixed the problem in the upcoming build.
The build will be available in a week or so.

Posted: Fri 04 Feb 2011 09:26
by AndreyR
The new build of dotConnect for PostgreSQL 5.10.96 is available.
It can be downloaded from here (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this announcement.

Posted: Wed 16 Feb 2011 09:54
by seser
Entity Developer (v 3.20.81) generates 'DbType = "INT4"' for column attributes for table and views, but generates 'DbType = "integer"' for function parameters.
this couse error when executing functions with turkish regional settings.

Posted: Thu 17 Feb 2011 12:58
by AndreyR
I have made some simple tests but failed to reproduce the issue using the latest 5.10.103 build of dotConnect for PostgreSQL.
Could you please send us the script of the objects (table and function) causing the issue?

Posted: Fri 18 Feb 2011 15:05
by seser
this error never occurs on development machines. and occurs some of the other machines. I'm trying to differentiate to system configuration for error.

but, if I replace all "integer" texts to "int4" then application works on all machines properly.

Posted: Mon 21 Feb 2011 12:09
by AndreyR
Hope you will be able to provide us either the scripts or some exact steps to reproduce the issue.