Re: Odd error in timestamp processing

We had this problem, too.  Very annoying.  It appears to be a bug in
7.1.x.  The way we got around it was to dump the DB out to a file and
run sed on the file with the script:
s/:60/:59/

Then feeding that output into psql.

Of course, our database doesn't use ':' followed by numbers for anything
but timestamps so your mileage may vary.

Hope this helps...

Cheers!

Bob

On Tue, 2002-07-23 at 14:14, Jeff Boes wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Robert M. Meyer
Sr. Network Administrator
DigiVision Satellite Services
14 Lafayette Sq, Ste 410
Buffalo, NY 14203-1904
(716)332-1451