restore dump to 8.19

Поиск
Список
Период
Сортировка
От mljv@planwerk6.de
Тема restore dump to 8.19
Дата
Msg-id 200707132111.44940.mljv@planwerk6.de
обсуждение исходный текст
Ответы Re: restore dump to 8.19  (Jim Nasby <decibel@decibel.org>)
Список pgsql-general
Hi

i tried to restore a dump from version 8.1.8 to 8.1.9 and i had in one table
a value "1.7383389519587511e-310"

i got the following error message:

pg_restore: ERROR:  type "double precision" value out of range: underflow
CONTEXT:  COPY gesamtpunktecache, line 925001, column
gc_gesamtsiege: "1.7383389519587511e-310"
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:  type "double
precision" value out of range: underflow
CONTEXT:  COPY gesamtpunktecache, line 925001, column
gc_gesamtsiege: "1.7383389519587511e-310"

i tried to insert a value of "1.7383389519587511e-310" to a 8.18 database but
i didn't manage it (with the same error message). But in one of my databases
i can select a value like this.

very strange. i just wanted to told you just in case it is of any interest and
maybe i can help with further informations.

kind regards,
janning


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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: multirow insert
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: restore dump to 8.19