| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Stian Riis <stian(dot)riis(at)elineweb(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: triggers |
| Date: | 2002-10-18 18:02:43 |
| Message-ID: | 200210181802.g9II2hi00535@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Stian Riis wrote:
> Hi.
>
> Does anyone know if it is posible to make a trigger that execute an
> external program ? I want to execute a another program on the server
> when I get a row in one of my tables...
Yes, you can use plperl and call an external program from there, or us
plsh and run it that way. plsh is mentioned on our web site under
interfaces.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-18 18:03:12 | Re: Locking that will delayed a SELECT |
| Previous Message | Bruce Momjian | 2002-10-18 18:01:18 | Re: functions that return a dataset or set of rows |