Interesting date/time 60 second problem with Postgresql - Mailing list pgsql-admin

From Will LaShell
Subject Interesting date/time 60 second problem with Postgresql
Date
Msg-id 1035238954.10932.39.camel@lyric.ofsloans.com
Whole thread Raw
Responses Re: Interesting date/time 60 second problem with Postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
We are in the process of moving an emergency servers old data from
Postgresql 7.1 to 7.2 and I got a very odd ( read as sucky ) error
when I went to psql -f the dump file.



psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR:  copy: line 44060,
Bad timestamp external representation '2002-10-07 09:55:60.00-07'
psql:/mnt/nfs/sql/replication_test.sql:603812: lost synchronization with
server, resetting connection


neat eh?

I looked in the database and it actually has that timestamp. Which btw
is defaulted to "now()"

I know there were time accuracy fixes put in, was this something that
was fixed?

Sincerely,

Will LaShell

Attachment

pgsql-admin by date:

Previous
From: Shawn Michael
Date:
Subject: Re: newbie qs; fixing and checking databases
Next
From: Tom Lane
Date:
Subject: Re: Interesting date/time 60 second problem with Postgresql