Re: how to execute a C program via trigger ?

Поиск
Список
Период
Сортировка
От Clayton Cottingham
Тема Re: how to execute a C program via trigger ?
Дата
Msg-id 200012051757.eB5HvsU81547@mail.postgresql.org
обсуждение исходный текст
Ответ на Re: how to execute a C program via trigger ?  ("S.F. Lee" <sflee_tw@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Kenn Thompson"
Дата:
Сообщение: RE: SQL parse error
Следующее
От: "Sivagami ."
Дата:
Сообщение: Foreign key constraint