Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8AHqJ723803 for ; Mon, 10 Sep 2001 13:52:20 -0400 (EDT) (envelope-from ler@lerctr.org) Received: from lerami.lerctr.org (localhost [127.0.0.1]) by lerami.lerctr.org (8.12.0/8.12.0/20010730/$Revision: 1.25 $) with ESMTP id f8AHpuqN022355; Mon, 10 Sep 2001 12:51:56 -0500 (CDT) Received: (from ler@localhost) by lerami.lerctr.org (8.12.0/8.12.0/Submit) id f8AHpu8g022354; Mon, 10 Sep 2001 17:51:56 GMT Date: Mon, 10 Sep 2001 12:51:55 -0500 From: Larry Rosenman To: Stephan Szabo Cc: Jeff Barrett , pgsql-sql@postgresql.org Subject: Re: calling a shell script from pl/pgsql Message-ID: <20010910125155.A21086@lerami.lerctr.org> References: <9nip2p$1s5o$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.22.1i X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200109/38 X-Sequence-Number: 4684 * Stephan Szabo [010910 12:37]: > On Mon, 10 Sep 2001, Jeff Barrett wrote: > > > How can I call a shell script from within a pl/pgsql function that is called > > as from a trigger. I do not want to interact with the script I just want it > > to run. I do want the trigger to wait for the script it called to complete > > before returning a value. > > > > Any ideas would be greatly appreciated. > > I don't think you can do that from within pl/pgsql. You'd probably need a > function in pl/tclu or c. You can also look at Peter Eisentraut's PL/sh, but there are portability issues with it: I can't seem to find the correct page at the moment, but it's out there. LER > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749