From: Richard Huxton <dev@archonet.com>
To: Stian Riis <stian@elineweb.com>
To: pgsql-sql@postgresql.org
Subject: Re: triggers
Date: Fri, 11 Oct 2002 15:19:06 +0100
Message-ID: <200210111519.06516.dev@archonet.com> (raw)
In-Reply-To: <000a01c2712c$d46e66e0$0200a8c0@dali>
References: <000a01c2712c$d46e66e0$0200a8c0@dali>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, stian@elineweb.com
Subject: Re: triggers
In-Reply-To: <200210111519.06516.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox