X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D2E09475B85 for ; Mon, 17 Feb 2003 01:27:13 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 62D43475A9E for ; Mon, 17 Feb 2003 01:27:08 -0500 (EST) Received: from lamer.pl (localhost [127.0.0.1]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 337D72B885; Mon, 17 Feb 2003 07:18:21 +0100 (CET) From: "Tomasz Myrta" To: "David Loh" , Subject: Re: Trigger that will execute external program Date: Mon, 17 Feb 2003 07:18:21 +0800 Message-Id: <20030217071821.M2591@klaster.net> In-Reply-To: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh> References: <001e01c2d64c$2ab838d0$f92c2c0a@davidloh> X-Mailer: Open WebMail 1.62 20020221 X-OriginatingIP: 217.96.97.171 (jasiek) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/364 X-Sequence-Number: 11762 > Hi all. > I'd like to know if postgresql has the capability of execute > external program with the trigger, for example, I had a trigger call > "exceed_limit", when this trigger has fire, instead of update other > relations, it will also execute a external program '/bin/send_email', > is that possble ? If it's possible, can any of you guy please show > me how to do it ? Thanks in advance. Read Postgresql documentation: 21.4. Trusted and Untrusted PL/Perl. Probably C functions have also ability for running system commands. Regards, Tomasz Myrta