Re: [GENERAL] Problem restoring db-dump on Postgres 8.0.4 Power5

2006-01-03 Thread Tom Lane
Peter Alberer" <[EMAIL PROTECTED]> writes: > Hmmm, i suspect the problem comes from the fact that i did not globally > change gcc to use -m64 nor did I set the enviroment flags (CFLAGS), but > changed the command in the makefile. The configure script did its tests with > the default -m32 and did no

Re: [GENERAL] Problem restoring db-dump on Postgres 8.0.4 Power5

2006-01-03 Thread Peter Alberer
Hmmm, i suspect the problem comes from the fact that i did not globally change gcc to use -m64 nor did I set the enviroment flags (CFLAGS), but changed the command in the makefile. The configure script did its tests with the default -m32 and did not define HAVE_LONG_INT_64. Maybe even INT64_IS_BUS

Re: [GENERAL] Problem restoring db-dump on Postgres 8.0.4 Power5

2006-01-03 Thread Peter Alberer
The platform is a redhat advanced server 4 update 2 for power5 64bit. the compiler is gcc: Reading specs from /usr/lib/gcc/ppc64-redhat-linux/3.4.4/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-

Re: [GENERAL] Problem restoring db-dump on Postgres 8.0.4 Power5

2006-01-03 Thread Tom Lane
"Peter Alberer" <[EMAIL PROTECTED]> writes: > The command > CREATE SEQUENCE assignment_task_elements_seq2 > INCREMENT BY 1 > MAXVALUE 9223372036854775807 > NO MINVALUE > CACHE 1; > Causes the following error: MINVALUE (1) must be less than MAXVALUE (-1) Not for me. What *exactl