Re: abstime bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: abstime bug
Date
Msg-id 6623.1122050671@sss.pgh.pa.us
Whole thread Raw
In response to Re: abstime bug  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Michael Fuhr wrote:
>> I'd guess this is due to the 32-bitness of abstime.  Those timestamps
>> are around the min and max values of a 32-bit timestamp based on the
>> traditional Unix epoch.

> Yea, I see the same thing in 8.0.X.  I don't think abstime should be
> used in that date range, timestamp is a better solution.

It's still a bug though; if the value is out of range, abstimein should
reject it, not misconvert it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1723: array_cat() bug when passed empty array
Next
From: Kris Jurka
Date:
Subject: Re: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB