Re: triggers - Mailing list pgsql-sql

From Richard Huxton
Subject Re: triggers
Date
Msg-id 200210111519.06516.dev@archonet.com
Whole thread Raw
In response to triggers  ("Stian Riis" <stian@elineweb.com>)
Responses Re: triggers
List 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


pgsql-sql by date:

Previous
From: "Stian Riis"
Date:
Subject: triggers
Next
From: Achilleus Mantzios
Date:
Subject: Re: triggers