pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Stian Riis <stian.riis@elineweb.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: triggers
Date: Fri, 18 Oct 2002 14:02:43 -0400 (EDT)
Message-ID: <200210181802.g9II2hi00535@candle.pha.pa.us> (raw)
In-Reply-To: <000401c2712c$79504a80$0200a8c0@dali>

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



view thread (34+ messages)  latest in thread

Message-ID: <200210181802.g9II2hi00535@candle.pha.pa.us>
Permalink:  ../200210181802.g9II2hi00535@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200210181802.g9II2hi00535@candle.pha.pa.us

 · 

reply

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: pgman@candle.pha.pa.us, stian.riis@elineweb.com
  Subject: Re: triggers
  In-Reply-To: <200210181802.g9II2hi00535@candle.pha.pa.us>

* 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