BUG #10457: Problem with double precision field.

From: maxim(dot)boguk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10457: Problem with double precision field.
Date: 2014-05-29 13:56:29
Message-ID: 20140529135629.10406.69681@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10457
Logged by: Maxim Boguk
Email address: maxim(dot)boguk(at)gmail(dot)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(at)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-05-29 14:19:10 Re: BUG #10457: Problem with double precision field.
Previous Message william.dubois 2014-05-28 21:58:49 BUG #10456: upgrade from 9.2.4 to 9.2.8 error