Re: Has anyone seen this SPARC bug? [Fwd: Bug#165060: postgresql:

This is fixed by building the Debian package without the --with-openssl 
flag passed into configure. I don't have time to look into it at the 
moment but doing a `./configure --with-openssl` has the side effect of 
no native 64bit type being found.

Brian Macy

Oliver Elphick wrote:
> 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 
> To: Debian Bug Tracking System 
> 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
> 
>