Re: BUG #5672: Can't input julian days BC - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5672: Can't input julian days BC
Date
Msg-id 26702.1285171917@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5672: Can't input julian days BC  ("Benjamin Gigot" <therealvaldor@hotmail.com>)
List pgsql-bugs
"Benjamin Gigot" <therealvaldor@hotmail.com> writes:
> After trying to enter Confucius birthday (28th September 551BC) I had the
> following error :

> Query failed: ERROR: date/time field value out of range: "J1520447"

Hmm ... this did work in versions before 8.4, but got broken as a
side-effect of tightening up error checking for other cases.  It
looks like we need to tweak ValidateDate() so that it won't throw
an error for BC dates when Julian notation was used.  Thanks for
the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005
Next
From: Andrew Geery
Date:
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005