Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Brian Macy
The config.log wasn't very useful but I hacked configure to not send compile/run errors to /dev/null and got this: checking whether long long int is 64 bits... ./conftest: relocation error: ./conftest: undefined symbol: __muldi3 Apparrently something is whacked when running from configure. I ca

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Brian Macy
Yeah, weird... Steve Dunham narrowed the problem down to libssl and posted it to the debian-sparc list, Ben Collins, and appended the info to the postgres bug report. Hopefully it will be resolved for Debian unstable shortly. Brian Macy Tom Lane wrote: Brian Macy <[EMAIL PROTECTED]> writes:

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Tom Lane
Brian Macy <[EMAIL PROTECTED]> writes: > The config.log wasn't very useful but I hacked configure to not send > compile/run errors to /dev/null and got this: > checking whether long long int is 64 bits... ./conftest: relocation > error: ./conftest: undefined symbol: __muldi3 > Apparrently somet

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Tom Lane
Brian Macy <[EMAIL PROTECTED]> writes: > checking whether long int is 64 bits... no > checking whether long long int is 64 bits... no Well, that seems to be the problem. Perhaps the relevant section of config.log would offer some hints? regards, tom lane

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Brian Macy
./configure --with-openssl This fails to find a 64bit native type. Brian Macy Lamar Owen wrote: On Thursday 17 October 2002 09:28 pm, Tom Lane wrote: Brian Macy <[EMAIL PROTECTED]> writes: Only excepts 32bit values and not 64bit. Endian issue? This is on sparc linux. Specifically Debia

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-18 Thread Lamar Owen
On Friday 18 October 2002 12:27 am, Brian Macy wrote: > Apparently there is something wrong with the PGAC configure macro. > Though I'm not clear as to why it fails when there is not native 64bit > type in the compiler. At least I would think it would fail the create > table if it isn't going to su

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-17 Thread Brian Macy
Apparently there is something wrong with the PGAC configure macro. Though I'm not clear as to why it fails when there is not native 64bit type in the compiler. At least I would think it would fail the create table if it isn't going to support the type. checking whether long int is 64 bits... n

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-17 Thread Brian Macy
Debian is 32bit user land. boaz:~# file /usr/lib/postgresql/bin/postgres /usr/lib/postgresql/bin/postgres: ELF 32-bit MSB executable, SPARC, version 1 (SYSV), for GNU/Linux 2.2.0, dynamically linked (uses shared libs), stripped Since it is debian it's prebuilt but i'll try building it myself

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-17 Thread Lamar Owen
On Thursday 17 October 2002 09:28 pm, Tom Lane wrote: > Brian Macy <[EMAIL PROTECTED]> writes: > > Only excepts 32bit values and not 64bit. Endian issue? > > This is on sparc linux. Specifically Debian. Aurora SPARC Linux does not suffer from this problem. On Aurora, the userland is 32 bit -- i

Re: [BUGS] Pg 7.2.3 int8 value out of range

2002-10-17 Thread Tom Lane
Brian Macy <[EMAIL PROTECTED]> writes: > Only excepts 32bit values and not 64bit. Endian issue? > This is on sparc linux. Hmm, did configure find any working 64bit int type? Let's see this part of your src/include/pg_config.h file: /* Set to 1 if type "long int" works and is 64 bits */ /* #unde

[BUGS] Pg 7.2.3 int8 value out of range

2002-10-17 Thread Brian Macy
Only excepts 32bit values and not 64bit. Endian issue? This is on sparc linux. 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: Fl