Re: question on trigger - Mailing list pgsql-general

From Daniel Åkerud
Subject Re: question on trigger
Date
Msg-id 000801c0fcaa$f4e2ad70$c901a8c0@automatic100
Whole thread Raw
In response to question on trigger  ("rui zhong" <rick_rui@hotmail.com>)
List pgsql-general
Judging by the error message, I would say it looks for a compiled version of
your file.

Daniel Åkerud


>
> Hi,all:
>
> This is my first time to use trigger. I try an example from programmer's
> guide. Firstly I save the procedure named trigf.c, then i try to comlile
it
> by using SQL statement " create function trigf() returns opaque as
> '...path_to_so' language 'c' ", then I got error message as " Load of file
> /home/postgres/trigf.c failed: invalid ELF header ".  I don't know how to
> fix this, please help me out. Lots of thanks.
>
> The including H file in trigf.c is :
>
>
> #include "executor/spi.h"  /*this is what you need to work with SPI */
> #include "commands/trigger.h"   /*-"- and triggers */
>
> extern Datum trigf(PG_FUNCTION_ARGS);
>
> PG_FUNCTION_INFO_V1(trigf);
>
> Datum
> trigf(PG_FUNCTION_ARGS)
> { ... }
>
>
>
>
> Rui
>
>
>
>
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>


----------------------------------------------------------------------------
----


>


----------------------------------------------------------------------------
----


>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-general by date:

Previous
From: Micah Yoder
Date:
Subject: Bug list?
Next
From: Daniel Åkerud
Date:
Subject: Harddisk performance degrading over time?