Recently we transferred our database from a 7.1 system to a 7.2 using:
$ pg_dump -h old_host | psql
During this, we saw this message:
ERROR: copy: line 15926, Bad timestamp external representation
'2002-07-21 06:54:60.00-04'
(It's the '60 seconds' part of the timestamp that is causing the problem,
I'm sure.) How might this have happened? Some kind of rounding error?
--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise