Re: triggers

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

In response to

  • triggers at 2002-10-11 13:48:07 from Stian Riis

Responses

  • Re: triggers at 2002-10-11 15:19:38 from Achilleus Mantzios

Browse pgsql-sql by date

  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