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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org, Brian Macy <bmacy(at)macykids(dot)net>
Subject: Re: Has anyone seen this SPARC bug? [Fwd: Bug#165060: postgresql: int8 value out of range on sparc]
Date: 2002-10-17 04:18:44
Message-ID: 6291.1034828324@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oliver Elphick <olly(at)lfix(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thirumoorthy Bhuvneswari 2002-10-17 04:22:38 Fetching as Date from a String
Previous Message Tom Lane 2002-10-17 03:52:38 Re: signals??