Interesting date/time 60 second problem with Postgresql

From: Will LaShell <will(at)lashell(dot)net>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Interesting date/time 60 second problem with Postgresql
Date: 2002-10-21 22:22:33
Message-ID: 1035238954.10932.39.camel@lyric.ofsloans.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-10-21 22:39:46 Re: Interesting date/time 60 second problem with Postgresql
Previous Message Shawn Michael 2002-10-21 19:37:06 Re: newbie qs; fixing and checking databases