Message-Id: <200012051757.eB5HvsU81547@mail.postgresql.org>
Content-Type: text/plain; charset="iso-8859-1"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
From: Clayton Cottingham <clayton@marketingchallenge.com>
To: "S.F. Lee" <sflee_tw@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to execute a C program via trigger ?
Date: 05 Dec 2000 09:58:41 PST
Reply-To: Clayton Cottingham <clayton@marketingchallenge.com>
In-Reply-To: <20001205022029.62885.qmail@web10401.mail.yahoo.com>
References: <20001205022029.62885.qmail@web10401.mail.yahoo.com>


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!