Hello!
1. Why "text" pgsql type is mapped to Type.VARCHAR?
a) In PostgreSqlPlatform.java is:
info.addNativeTypeMapping(Types.LONGVARCHAR, "TEXT", Types.VARCHAR);
b) IMO should be:
info.addNativeTypeMapping(Types.LONGVARCHAR, "TEXT", Types.LONGVARCHAR);
2. "timestamp" and "time" should have:
info.setHasSize(Types.TIMESTAMP, true);
info.setHasSize(Types.TIME, true);
Ref: PgSQL 8.0.3 Doc; 8.5. Date/Time Types; Table 8-9. Date/Time Types
3. COMMENT ON TABLE/COLUMN support should be added
4. No support for onUpdate/onDelete attributes of foreign-key element.
Very easy in implementation:
alter table cgrupa2
add constraint fk_cgrupa2_gkom1 foreign key (gkom1_id)
references gkom1 (gkom1_id) ON UPDATE CASCADE ON DELETE RESTRICT;
--
Przemysław Sztoch <[EMAIL PROTECTED]>
Mobile +48 (502) 400 239, GG 569973
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
