Re: Problems with 8.4, FLOAT8PASSBYVAL and x86_64 GNU/Linux

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Peter Eisentraut wrote:
> On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
>> ERROR: incompatible library "/usr/local/lib/pg_uname_8.4.so": magic
>> block mismatch
>> DETAIL: Server has FLOAT8PASSBYVAL = true, library has false.
>
> You need to recompile your module.

Hei

We recompile the module automatically when a new postgres cluster gets
installed. The module has been compiled locally on the 64bit server that
is going to use it.

Any other ideas?

This is the Makefile we use:
- ---------------------------------------
PG_SRC=/usr/local/src
PG_LIB=/usr/local/lib
SERVER_INCLUDES += -I $(shell /local/opt/pgsql-8.4/bin/pg_config
- --includedir)
SERVER_INCLUDES += -I $(shell /local/opt/pgsql-8.4/bin/pg_config
- --includedir-server)

CFLAGS = $(SERVER_INCLUDES)
CC = gcc

all: clean pg_uname_8.4 install

pg_uname_8.4: pg_uname_8.4.c
$(CC) $(CFLAGS) -fpic -c $<
$(CC) $(CFLAGS) -shared -o $(basename $<).so $(basename
$<).o

install:
cp $(PG_SRC)/pg_uname_8.4.so $(PG_LIB)/pg_uname_8.4.so

clean:
rm -f *.o
rm -f *.so
rm -f *~
- ---------------------------------------

regards,
- --
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux)

iD8DBQFKXvoZBhuKQurGihQRAiJdAJ9HBG33gDF16Uiu+Z5QvGDHtnzj7gCaAmBz
Lfll6Lshy8shhLK62lb3fMs=
=sIud
-----END PGP SIGNATURE-----