BUG #10457: Problem with double precision field.

Поиск
Список
Период
Сортировка
От maxim.boguk@gmail.com
Тема BUG #10457: Problem with double precision field.
Дата
Msg-id 20140529135629.10406.69681@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #10457: Problem with double precision field.
Re: BUG #10457: Problem with double precision field.
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      10457
Logged by:          Maxim Boguk
Email address:      maxim.boguk@gmail.com
PostgreSQL version: 9.0.17
Operating system:   Linux
Description:

Hi I have one database with table which I could not restore via
pg_dump/pg_restore.

I localized the problem at double precision values which could not be
inserted into double precision (weird it is).

[local]:5432 postgres@comon3=#  select record_rating from rating.record
where record_rating>0 order by 1 limit 50;
    record_rating
----------------------
 6.5397686164648e-309
 8.1108289380243e-309
 2.0326868922821e-308
and so on...

But:
select '6.5397686164648e-309'::double precision;
ERROR:  "6.5397686164648e-309" is out of range for type double precision
LINE 2: select '6.5397686164648e-309'::double precision;

select record_rating::text::double precision from rating.record where
record_rating>0 order by record_rating limit 10;
ERROR:  "6.5397686164648e-309" is out of range for type double precision

So somehow double precision field could content value which could not be
inserted into it again.
Any ideas what's wrong with the database welcome.


PS: table structure:
 obj_id                            | bigint                   | not null
default nextval('rating.record_obj_id_seq'::regclass)
 obj_created                       | timestamp with time zone | not null
default now()
 obj_modified                      | timestamp with time zone | not null
default now()
 obj_status_did                    | smallint                 | not null
default 1
 record_rating                     | double precision         |
 record_rating_without_attenuation | double precision         | default 0
Indexes:
    "record_pkey" PRIMARY KEY, btree (obj_id)

Kind Regards,
Maksym

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

Предыдущее
От: william.dubois@recommind.com
Дата:
Сообщение: BUG #10456: upgrade from 9.2.4 to 9.2.8 error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #10457: Problem with double precision field.