Re: Has anyone seen this SPARC bug? [Fwd: Bug#165060: postgresql: - Mailing list pgsql-general

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 <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
>
>