Re: Exclude constraint problem - Mailing list pgsql-bugs

Jeff Davis <pgsql@j-davis.com> writes:
> On Mon, 2010-08-30 at 19:40 -0400, Tom Lane wrote:
>> That's really *not* supposed to happen, assuming that both machines have
>> IEEE float arithmetic and competently written float I/O code.

> On my machine I see:

> => select float4in(float4out((1::numeric + 1e-7::numeric)::float4)) =
>      (1::numeric + 1e-7::numeric)::float4;

You need extra_float_digits cranked up.  Which pg_dump knows about.

            regards, tom lane