Postgres Pro
Downloads
Home   >   mailing lists

Odd error in timestamp processing - Mailing list pgsql-admin

From Jeff Boes
Subject Odd error in timestamp processing
Date
Msg-id ahk6em$uo5$1@news.hub.org
Whole thread Raw
Responses Re: Odd error in timestamp processing  ("Robert M. Meyer" <rmeyer@installs.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: Postgres performance slowly gets worse over a month
Next
From: Jeff Boes
Date:
Subject: Recurring 'FATAL 1' error in postmaster log