Обсуждение: Interesting date/time 60 second problem with Postgresql

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

Will LaShell <will@lashell.net> writes:
> psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR:  copy: line 44060,
> Bad timestamp external representation '2002-10-07 09:55:60.00-07'

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

Yeah, this is an old bug.  You'll need to use sed or something to find
and fix the dump lines containing '60.00'.

            regards, tom lane