db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Przemysław Sztoch <jna...@navy.main.pl>
Subject PostgreSQL platform (text type)
Date Thu, 09 Mar 2006 23:54:22 GMT
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 <jnavy1@navy.main.pl>
Mobile +48 (502) 400 239, GG 569973

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message