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.m.guerrero@usit.uio.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-----