Re: 'Bad timestamp external representation' error when restoring database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 'Bad timestamp external representation' error when restoring database
Дата
Msg-id 27023.1031147645@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 'Bad timestamp external representation' error when restoring database  (Søren Neigaard <s.neigaard@mobilethink.dk>)
Список pgsql-general
=?iso-8859-1?Q?S=F8ren_Neigaard?= <s.neigaard@mobilethink.dk> writes:
> ERROR:  copy: line 3580, Bad timestamp external representation '2002-08-23
> 08:31:60.00+02'
> PQendcopy: resetting connection

This is a known bug in older PG releases: sometimes a time like
"08:31:59.999" is mistakenly rounded off as "08:31:60.00" which of course
the timestamp reader code thinks is bogus.  I'm afraid you have little
choice but to edit the dump file to fix the broken timestamps (a sed
script might help here).

You should think about updating to a more recent release ---
AFAIK this problem is fixed in 7.2.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Please help - Keep getting authentication failure when trying to restore database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: clog problem