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

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@macykids.net>
To: Debian Bug Tracking System <submit@bugs.debian.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.Elphick@lfix.co.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