Data Modeling Problems

[Piotr]

I have problem with Data Modeling using EA.
Problem description :
System : PostgreSQL with ODBC (linux server)
I have imported the base structure into EA.
There were no postgres datatypes just some ints longs etc
but no int2 int4
I have (i think so) described pgsql data types to EA and
changed the types from imported tables to postgres types.

and i cannot export default values ...

please describe me how to set default values for columns
in ddl exported file

[sparks]

Hello,

At the moment EA does not support the import of PostgreSQL database information through ODBC, and because each database product has different names for the same datatypes.  ie a 32 bit integer in one product is called 'int' and in another 'int32' or 'int2'.  The ODBC driver converts each datatype to generic name, that is why EA imports the wrong datatypes from your PostgreSQL database definition.

As I mentioned in another post, default values are not supported at the moment, however they are on our to-do list and we will be adding support for this in the future.

Paul Mathers