Interesting date/time 60 second problem with Postgresql

Поиск
Список
Период
Сортировка
Искать

Interesting date/time 60 second problem with Postgresql

От:
Will LaShell <will@lashell.net>
Дата:
Вложения:
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

Re: Interesting date/time 60 second problem with Postgresql

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Will LaShell  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
FAQ