Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and psql disagree on numerical precision (powerpc) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_dump and psql disagree on numerical precision (powerpc)
Date
Msg-id 20325.1068821432@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and psql disagree on numerical precision (powerpc)  (Christof Petig <christof@petig-baender.de>)
Responses Re: pg_dump and psql disagree on numerical precision (powerpc)  (Christof Petig <christof@petig-baender.de>)
List pgsql-bugs
Tree view 
Christof Petig <christof@petig-baender.de> writes:
> COPY test (x) FROM stdin;
> 0.29999999999999999
> \.

This is not a bug; it's pg_dump trying to recreate the actual floating
point value as accurately as it can.  See the discussion of
extra_float_digits from six months or a year back.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Christof Petig
Date:
Subject: pg_dump and psql disagree on numerical precision (powerpc)
Next
From: Christof Petig
Date:
Subject: Re: pg_dump and psql disagree on numerical precision (powerpc)