Execute external program on a trigger

[madelman]

Hi!!

I'm trying to execute an external program when a trigger occurs, but I've run into a problem.

I've been able to define a 'C' function which executes when the trigger occurs, but I don't know how to execute the external program from this 'C' function. I tried with the instruction 'system' but it doesn't seem to work.

Any help will be appreciated.

Thanls.

 

[Leland123]

Hi madelman,

You might try the following links:

http://www.ca.postgresql.org/docs/aw_pgsql_book/node168.html#extending_chapter

http://www.ca.postgresql.org/docs/aw_pgsql_book/node166.html

Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox

 

[rycamor]

I know of at least one easy way to execute an external function with a trigger: install Perl as a language handler in 'untrusted' mode. (

http://www.postgresql.org/idocs/index.php?plperl.html).

This means you have full access to any of Perl's functionality, including its ability to execute system commands, handle return codes, network functions, etc... -------------------------------------------

Big Brother: "War is Peace" -- Big Business: "Trust is Suspicion"
(

http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html)