timezone incompatibility

Hi,

I'm testing our auto-configuration persistence framework (acp) against
several databases and now that it comes to PostgreSQL, I run into a timezone
incompatibility compared to other jdbc-drivers/databases. The framework
tests the database specific datatypes by inserting a value, retrieving it
and comparing the result. Here is the result for timestamp:

 Insert and Retrieve of SQLType 93 test value <Sun Jun 20 20:16:54 CEST
1756> failed. Retrieved after insert: <Sun Jun 20 18:16:54 CEST 1756>

I tried it with a test value in 1992 and the test passes.
Okay, the docs say:
"PostgreSQL uses your operating system's underlying features to provide
output time-zone support, and these systems usually contain information for
only the time period 1902 through 2038 (corresponding to the full range of
conventional Unix system time)."

But nevertheless, I feel sick with this behaviour, to me it seems not to be
correct and it makes PostgreSQL incompatible to other databases. The
databases I have tested so far retrieve the correct date  before 1902.


regards
Wolfgang



Dr. Wolfgang Winter
LogiTags Systems
http://www.logitags.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster