Re: Has anyone seen this SPARC bug? [Fwd: Bug#165060: postgresql: int8 value out of range on sparc] - Mailing list pgsql-general

Oliver Elphick <olly@lfix.co.uk> writes:
> This is a Debian bug report from a SPARC user.  It doesn't happen for me
> on i386 7.2.3.

> com.pany=# insert into foo values (1034784236789);
> ERROR:  Floating point conversion to int8 is out of range

I'm betting that rint() is broken on this platform.  It would be useful
to trace through the execution of dtoi8() (in src/backend/utils/adt/int8.c)
to see exactly why it's spitting up.

            regards, tom lane