Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-06 Thread Andy Shellam
That sounds like you hadn't yet figured out to set CFLAGS too. Google or no Google, you're setting the wrong variable. I had to install PG 8.3.7 on another couple of machines today, and got exactly the same issue (setting all 3 variables) again on the SPI module. Please see as

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-06 Thread Tom Lane
Andy Shellam andy-li...@networkmail.eu writes: I had to install PG 8.3.7 on another couple of machines today, and got exactly the same issue (setting all 3 variables) again on the SPI module. Please see as follows: FWIW, it does appear that 8.4 makes this better.

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-06 Thread Andy Shellam
FWIW, it does appear that 8.4 makes this better. OK cheers, I have got plans to migrate over the next month or two; just wanted to point out the issue. Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

[ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-05 Thread Andy Shellam
I was going to post this to pgsql-hackers but figured it might be more suitable on this list first. I'm trying to compile a 32-bit PostgreSQL client on a 64-bit system, however the SPI module is not respecting the CFLAGS and LDFLAGS option -m32. My configure line is as follows: CFLAGS=-m32

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-05 Thread Andy Shellam
Tom, Doubtless, your problem is that you're setting LD not LDFLAGS. Nope, I originally had LDFLAGS set to -m32 instead of LD, and it failed with another error trying to link the localtime.o object (which it had compiled as 64-bit) to create SYS-something-or-other.o (which it was trying

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-05 Thread Tom Lane
Andy Shellam andy-li...@networkmail.eu writes: Tom, Doubtless, your problem is that you're setting LD not LDFLAGS. Nope, I originally had LDFLAGS set to -m32 instead of LD, and it failed with another error trying to link the localtime.o object (which it had compiled as 64-bit) to create

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-05 Thread Andy Shellam
Tom, That sounds like you hadn't yet figured out to set CFLAGS too. Actually if you see my first post, the only thing I'd changed was replaced LDFLAGS=-m32 with the LD variable and I had also tried adding that back in alongside CFLAGS and LD but to no avail. I compiled the module by hand

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

2009-07-05 Thread Tom Lane
Andy Shellam andy-li...@networkmail.eu writes: I was going to post this to pgsql-hackers but figured it might be more suitable on this list first. I'm trying to compile a 32-bit PostgreSQL client on a 64-bit system, however the SPI module is not respecting the CFLAGS and LDFLAGS option