Horton

Re: Integer datetimes

Neil Conway <neilc@samurai.com>

View thread View on postgr.es
From: Neil Conway <neilc@samurai.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Jim Nasby <decibel@decibel.org>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2007-05-06T18:31:53Z
Lists: pgsql-hackers 
On Sun, 2007-06-05 at 13:09 -0400, Bruce Momjian wrote:
> Also, are we sure we can load a dump that used the float format?  What
> happens for a date out of int8 range?

AFAIK we should always be able to reload timestamp values that are in
the legal range for an int8-based timestamp. For values outside that
range, the restore will fail, just as it would if you tried to move an
application from PG 8.2 with float timestamps to PG 8.2 with integer
timestamps. The user can always reconfigure with
--disable-integer-datetimes.

-Neil