Thread: Upgrading from 8.3 to 8.4 and Integer datatimes?
Will a dump and restore take care of this change or do I have to do some manual converting when upgrading? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen btj@havleik.no ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" -----------------------------------------------------------------------------------------------
On Jul 28, 2009, at 8:48 , Bjørn T Johansen wrote: > Will a dump and restore take care of this change or do I have to do > some manual converting when upgrading? Dump and reload should be fine. While the binary format of the timestamp values is different in the *database*, the text output of pg_dump is independent of the binary format: timestamps (and other values) are literal representations. As always, for your own edification and assurance, I'd test this with both a small, toy database and with your production database before your final upgrade. Michael Glaesemann grzm seespotcode net