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 52FF4D1C9BE for ; Fri, 16 Apr 2004 17:20:26 -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 68181-04 for ; Fri, 16 Apr 2004 17:20:17 -0300 (ADT) Received: from axiontech.com (unknown [216.52.172.78]) by svr1.postgresql.org (Postfix) with SMTP id 71305D1BAF5 for ; Fri, 16 Apr 2004 17:20:19 -0300 (ADT) Received: (qmail 11331 invoked from network); 16 Apr 2004 20:20:28 -0000 Received: from pc-00132 (HELO yudie) (192.168.1.132) by mail.axiontech.com (192.168.1.6) with SMTP; 16 Apr 2004 20:20:28 -0000 Message-ID: <000001c423f0$399250f0$8401a8c0@home.axiontech.com> From: "Yudie" To: References: <200404151507.RAA03297@rodos> <1082063227.5415.217.camel@hklog> Subject: Re: Update is very slow on a bigger table Date: Fri, 16 Apr 2004 12:47:58 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/149 X-Sequence-Number: 17524 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. Yudie