Received: from id.godlike.com (id.godlike.com [206.205.199.129]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA17332 for ; Tue, 25 Aug 1998 14:27:01 -0400 (EDT) Received: from taral (171-208-168.ipt.aol.com [152.171.208.168]) by id.godlike.com (8.8.5/8.8.5) with SMTP id OAA13005; Tue, 25 Aug 1998 14:26:30 -0400 (EDT) From: "Taral" To: "Jose David Martinez Cuevas" , Subject: RE: [SQL] Having problems to compile SPI Date: Tue, 25 Aug 1998 13:26:30 -0500 Message-ID: <000401bdd055$e11fd800$3b291f0a@taral> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 In-Reply-To: Importance: Normal 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 > ---------------------------------------- > > > > > > >