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

This is a Debian bug report from a SPARC user. It doesn't happen for me
on i386 7.2.3.

Can anyone reproduce it or suggest a reason for it?

-----Forwarded Message-----

From: Brian Macy <bmacy(at)macykids(dot)net>
To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)org>
Subject: Bug#165060: postgresql: int8 value out of range on sparc
Date: 16 Oct 2002 09:46:46 -0700

Package: postgresql
Version: 7.2.3-0.1
Severity: grave
Tags: sid upstream
Justification: renders package unusable

Only excepts 32bit values and not 64bit. Endian issue?

This is on sparc.

com.pany=# create table foo (val bigint);
CREATE
com.pany=# insert into foo values (1034784236789);
ERROR: Floating point conversion to int8 is out of range
com.pany=# insert into foo values (103478423678);
ERROR: Floating point conversion to int8 is out of range
com.pany=# insert into foo values (10347842367);
ERROR: Floating point conversion to int8 is out of range
com.pany=# insert into foo values (1034784236);
INSERT 16872 1

I also got this on a restore with inserts from a remote machine.
psql:restore.sql:124576: ERROR: int8 value out of range:
"1033219132976"
psql:restore.sql:124577: ERROR: int8 value out of range:
"1033217951899"
psql:restore.sql:124578: ERROR: int8 value out of range:
"1033220352916"
psql:restore.sql:124579: ERROR: int8 value out of range:
"1033217955384"

Brian Macy

-- System Information:
Debian Release: testing/unstable
Architecture: sparc
Kernel: Linux boaz 2.4.19 #1 SMP Sat Oct 5 16:03:12 EDT 2002 sparc64
Locale: LANG=C, LC_CTYPE=C

Versions of packages postgresql depends on:
ii adduser 3.48 Add and remove users and groups
ii debianutils 1.16.6 Miscellaneous utilities specific t
ii libc6 2.2.5-15 GNU C Library: Shared libraries an
ii libpam0g 0.76-6 Pluggable Authentication Modules l
ii libpgsql2 7.2.3-0.1 Shared library libpq.so.2 for Post
ii libreadline4 4.3-4 GNU readline and history libraries
ii libssl0.9.6 0.9.6g-9 SSL shared libraries
ii postgresql-client 7.2.3-0.1 Front-end programs for PostgreSQL
ii procps 1:3.0.3-1 The /proc file system utilities.
ii python2.2 2.2.2-1 An interactive object-oriented scr
ii zlib1g 1:1.1.4-6 compression library - runtime

-- no debconf information

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But be ye doers of the word, and not hearers only,
deceiving your own selves." James 1:22