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