-----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@xxxxxxxxxxx> 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general