Hello, I have a question regarding the integer type and ddl script generation. I'm using empire-db with postgre-sql and apache derby. I'd like the primary keys to be BIGINT and not INT and I didn't find a good way how to tell empiredb when to use BIGINT and when to use INT - the datatype is DataType.INTEGER and the drivers for postgre and derby do always say INT (not sure about the newest trunk version).
What I do is overwriting the method boolean appendColumnDesc(DBTableColumn c, StringBuilder sql, boolean alter) of the DBDatabaseDriver class and checking for an given size. So a column with DataType.INTEGER and size=8 is then created as BIGINT. Did I miss something, or how would you recommend to address this? Thanks in advance Eike
