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