Re: BUG #5672: Can't input julian days BC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Benjamin Gigot" <therealvaldor(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5672: Can't input julian days BC
Date: 2010-09-22 16:11:57
Message-ID: 26702.1285171917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Benjamin Gigot" <therealvaldor(at)hotmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Geery 2010-09-22 16:23:03 Re: BUG #5669: server process was terminated by exception 0xC0000005
Previous Message Tom Lane 2010-09-22 15:58:28 Re: BUG #5669: server process was terminated by exception 0xC0000005