X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 85CF3D1C9DA for ; Sat, 17 Apr 2004 12:09:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48299-03 for ; Sat, 17 Apr 2004 12:09:58 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 428E1D1BCB8 for ; Sat, 17 Apr 2004 12:09:57 -0300 (ADT) Received: (qmail 14813 invoked by uid 500); 17 Apr 2004 15:13:47 -0000 Date: Sat, 17 Apr 2004 10:13:47 -0500 From: Bruno Wolff III To: Yudie Cc: pgsql-sql@postgresql.org Subject: Re: Update is very slow on a bigger table Message-ID: <20040417151347.GA14656@wolff.to> Mail-Followup-To: Yudie , pgsql-sql@postgresql.org References: <200404151507.RAA03297@rodos> <1082063227.5415.217.camel@hklog> <000001c423f0$399250f0$8401a8c0@home.axiontech.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <000001c423f0$399250f0$8401a8c0@home.axiontech.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/152 X-Sequence-Number: 17527 On Fri, Apr 16, 2004 at 12:47:58 -0500, Yudie wrote: > Hi guys, > I would like to create a trigger that execute some programs, > is there a way to create a plpgsql function that execute shell command or > any other way to run a program? > Thanks for your help. Only untrusted languages can be used to run external programs. perlu might be something you can use.