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
> ----------------------------------------
>
>
>
>
>
>
>