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

2009-07-16 Thread Alvaro Herrera
Rafael Martinez wrote: > 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

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

2009-07-16 Thread Rafael Martinez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marko Kreen wrote: > On 7/16/09, Rafael Martinez wrote: >> >> Any other ideas? >> > >> > The version you compile against is not the version you have running. >> > >> >> Well, the only version I have installed on this server is 8.4.0 > > Yes, bu

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

2009-07-16 Thread Marko Kreen
On 7/16/09, Rafael Martinez wrote: > Marko Kreen wrote: > > On 7/16/09, Rafael Martinez wrote: > >> Peter Eisentraut wrote: > >> > > > >> > You need to recompile your module. > >> > >> We recompile the module automatically when a new postgres cluster gets > >> installed. The module has

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

2009-07-16 Thread Rafael Martinez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marko Kreen wrote: > On 7/16/09, Rafael Martinez wrote: >> Peter Eisentraut wrote: >> > >> > You need to recompile your module. >> >> We recompile the module automatically when a new postgres cluster gets >> installed. The module has been compiled

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

2009-07-16 Thread Marko Kreen
On 7/16/09, Rafael Martinez wrote: > 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. > > > >

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

2009-07-16 Thread Rafael Martinez
-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

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

2009-07-16 Thread Peter Eisentraut
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. -- Sent via pgsql-general mailing list (pgsql-gener

[GENERAL] Problems with 8.4, FLOAT8PASSBYVAL and x86_64 GNU/Linux

2009-07-16 Thread Rafael Martinez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello We have a C function that works without problems when we use it with postgresql 8.3 (32/64bit) and with postgreSQL 8.4 (32bit). But with 8.4 in a 64bit server, postgresql generates this error when we try to install the function: ERROR: incomp