pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Having problems to compile SPI
2+ messages / 2 participants
[nested] [flat]

* Having problems to compile SPI
@ 1998-08-25 18:07  Jose David Martinez Cuevas <david@morgana.estadistica.unam.mx>
  0 siblings, 1 reply; 2+ messages in thread

From: Jose David Martinez Cuevas @ 1998-08-25 18:07 UTC (permalink / raw)
  To: pgsql-sql


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









^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: [SQL] Having problems to compile SPI
@ 1998-08-25 18:26  Taral <taral@mail.utexas.edu>
  parent: Jose David Martinez Cuevas <david@morgana.estadistica.unam.mx>
  0 siblings, 0 replies; 2+ messages in thread

From: Taral @ 1998-08-25 18:26 UTC (permalink / raw)
  To: Jose David Martinez Cuevas <david@morgana.estadistica.unam.mx>; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-08-25 18:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-25 18:07 Having problems to compile SPI Jose David Martinez Cuevas <david@morgana.estadistica.unam.mx>
1998-08-25 18:26 ` Taral <taral@mail.utexas.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox