BUG #5747: TimeStamps too far into the future are invalid - Mailing list pgsql-bugs

From Kurt Stam
Subject BUG #5747: TimeStamps too far into the future are invalid
Date
Msg-id 201011101547.oAAFlaCc013378@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5747: TimeStamps too far into the future are invalid  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5747
Logged by:          Kurt Stam
Email address:      kstam@apache.org
PostgreSQL version: 8.3
Operating system:   OSX
Description:        TimeStamps too far into the future are invalid
Details:

https://issues.apache.org/jira/browse/JUDDI-374

When the coverage period goes out too far postgres has issues. The coverage
periods are specified in the uddi-tck-base module in the directory
src/main/resources/uddi_data/subscription; the files
subscriptionresults3.xml and subscriptionresults4.xml:

Changing the endPoint from 2100 to 2030.

This is clearly a bug in postgres or the postgres driver. On saving no error
is thrown, however the endpoint field is set to 'invalid' which is an issue
when the date is parsed back into a timedate.

pgsql-bugs by date:

Previous
From: Mike Fowler
Date:
Subject: Re: BUG #5745: geometry bug?
Next
From: Tom Lane
Date:
Subject: Re: BUG #5745: geometry bug?