Re: how to execute a C program via trigger ? - Mailing list pgsql-sql

From Clayton Cottingham
Subject Re: how to execute a C program via trigger ?
Date
Msg-id 200012051757.eB5HvsU81547@mail.postgresql.org
Whole thread Raw
In response to Re: how to execute a C program via trigger ?  ("S.F. Lee" <sflee_tw@yahoo.com>)
List pgsql-sql
On Mon, 4 Dec 2000 18:20:29 -0800 (PST), S.F. Lee said:

> Thank for your hint, but I have some questions :
>  
>    1. Do I have to compile the C program into a shared
>  object (*.so)? 

yes

>    2. Do I have to use SPI (SPI is too complicate to
>  me)? 
>  
>    My request is very simple. I have a program
>  (my_c_program) 
>    that I can execute it under shell by typing
>  (my_c_program).
>    Basically my_c_program is not a function.
>  


im not sure anyone?


>    I want to fire a trigger after I update the field
>  (x) in table foo, and the trigger can run the
>  my_c_program. Is there an easy way to execute a
>  PROCESS
>  via trigger?
>  
>     regards,    S.F. Lee
>  


id say dont use C!! use pl/sql 

but if your trying to learn the prog of c functions
youll have to get help elsewhere unfortunatley

im not even newbie status on c!


pgsql-sql by date:

Previous
From: "Kenn Thompson"
Date:
Subject: RE: SQL parse error
Next
From: "Sivagami ."
Date:
Subject: Foreign key constraint