Interesting date/time 60 second problem with Postgresql

Поиск
Список
Период
Сортировка
От Will LaShell
Тема Interesting date/time 60 second problem with Postgresql
Дата
Msg-id 1035238954.10932.39.camel@lyric.ofsloans.com
обсуждение исходный текст
Ответы Re: Interesting date/time 60 second problem with Postgresql
Список 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

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Shawn Michael
Дата:
Сообщение: Re: newbie qs; fixing and checking databases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interesting date/time 60 second problem with Postgresql