Re: pg_dump fails (timestamp out of range)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump fails (timestamp out of range)
Дата
Msg-id 5458.1172159013@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump fails (timestamp out of range)  (T E Schmitz <mailreg@numerixtechnology.de>)
Ответы Re: pg_dump fails (timestamp out of range)  (T E Schmitz <mailreg@numerixtechnology.de>)
Список pgsql-sql
T E Schmitz <mailreg@numerixtechnology.de> writes:
> However, I am stalled because pg_dump fails with the following error:

> pg_dump: ERROR:  timestamp out of range
> pg_dump: SQL command to dump the contents of table "server_hit_bin"
> failed: PQendcopy() failed.

You should treat this as a corrupt-data exercise: you need to identify
and fix (or delete) the offending row(s).  In this case you might try
tests like "bin_end_date_time > '1 Jan 9999'" and so on to see if you
can determine exactly which rows are bad.
        regards, tom lane


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

Предыдущее
От: "Sabin Coanda"
Дата:
Сообщение: Re: How compare current_setting(..) ?
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: DISTINCT ON not working... RESOLVED