Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CFE64476908 for ; Fri, 18 Oct 2002 14:03:04 -0400 (EDT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 792FA4764ED for ; Fri, 18 Oct 2002 14:03:02 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g9II2hi00535; Fri, 18 Oct 2002 14:02:43 -0400 (EDT) From: Bruce Momjian Message-Id: <200210181802.g9II2hi00535@candle.pha.pa.us> Subject: Re: triggers In-Reply-To: <000401c2712c$79504a80$0200a8c0@dali> To: Stian Riis Date: Fri, 18 Oct 2002 14:02:43 -0400 (EDT) Cc: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/238 X-Sequence-Number: 9955 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