Skip site navigation (1) Skip section navigation (2)

Odd error in timestamp processing

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Odd error in timestamp processing
Date: 2002-07-23 18:14:53
Message-ID: ahk6em$uo5$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Marcos GarciaDate: 2002-07-23 18:18:02
Subject: Re: Postgres performance slowly gets worse over a month
Previous:From: Naomi WalkerDate: 2002-07-23 18:08:30
Subject: Re: Postgres performance slowly gets worse over a month

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group