RE: [SQL] Having problems to compile SPI

Aren't you supposed to link SPI functions as shared libraries?

Try: gcc -shared -o cascade.so cascade.o

Taral

> -----Original Message-----
> From: owner-pgsql-sql@hub.org [mailto:owner-pgsql-sql@hub.org]On Behalf
> Of Jose David Martinez Cuevas
> Sent: Tuesday, August 25, 1998 1:07 PM
> To: pgsql-sql@postgreSQL.org
> Subject: [SQL] Having problems to compile SPI
>
>
>
> Hi.
>
> I hope this is not a too much trivial question.
>
> I'm having problems when compiling a new SPI function. I've been doing it
> with :
>
>     gcc -I/usr/src/postgresql-6.3.2/src/include
>        -I/usr/src/postgresql-6.3.2/src/backend
>        -Wall -Wmissing-prototypes
>        -fpic -I/usr/src/postgresql-6.3.2/src/include
>        -c cascade.c -o cascade.o
>
> but when I call de .o file from the function attached to the trigger , I
> get the next message:
>
>
>     ERROR:  Load of file /SAP/SQL/funcs/spi/cascade.o failed:
>             /SAP/SQL/funcs/spi/cascade.o: ELF file's phentsize not the
>             expected size
>
> What can I do ???
>
> _______________________________________
> David Martinez Cuevas
> Direccion General de Estadistica, UNAM - Mexico
> Tel. 622-60-80
> E-mail david@estadistica.unam.mx
> ----------------------------------------
>
>
>
>
>
>
>