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