Hi Tom/Gordon/King
Here is the first cut at introducing support for Postgres sql
database. I have attached the files to this email. It would be great if
U could review these files and provide Ur inputs.
1. oracle/toplink/essentials/tools/schemaframework/FieldDefinition.java :
Have moved the writing of field size and unique string to the
database platform. This was because for PostGres the is a SERIAL field
(this is the equivalent of IDENTITY column). When defining this column
all U provide is <NAME_OF_THE_COLUMN> SERIAL <NULL/NOT NULL. But in the
existing code we were always printing out the field size and/or Unique
(tag if required). Now I have moved these to the DatabasePlatform.java
and have overwritten them in PostgreSQLPlatform.
2. oracle/toplink/essentials/internal/databaseaccess/DatabasePlatform.java
Have refactored code into a new method called
"isShouldAcquireSequenceValueAfterInsert". This code was previously
present in the method "printFieldIdentityClause". I needed this
refactored code to know if I need to skip the writing of the field size
and UNIQUE tag.
3. ./oracle/toplink/essentials/platform/database/PostgreSQLPlatform.java
Platform related to Postgres
Thanks
Pramod