On 15 August 2011 16:56, Steve Singer <ssin...@ca.afilias.info> wrote: > This would mean that anyone using the floating point timestamps today won't > be able to use pg_upgrade to upgrade to whichever version we remove them > from. 8.3 had float based timestamps as the default and I suspect many > installations with the default 8.3 settings have been upgraded via > pg_upgrade to 9.0 built the old timestamps representation.
Really? I find that slightly surprising, considering that a quick look at master's timestamp.c suggests that the choice to use the in64 representation over the double representation is entirely a case of compile time either/or. There is no apparent fall-back to the double representation available to binaries built without --disable-integer-datetimes. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers