| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Stian Riis" <stian(at)elineweb(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: triggers |
| Date: | 2002-10-11 14:19:06 |
| Message-ID: | 200210111519.06516.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Friday 11 Oct 2002 2:48 pm, 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...
The customary way is to have a "helper" process that sits there LISTENing for
a NOTICE and then calls the external program as required. Cleaner and means
the other program doesn't have any direct connection to the Postgresql
backend.
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2002-10-11 15:19:38 | Re: triggers |
| Previous Message | Stian Riis | 2002-10-11 13:48:07 | triggers |