Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8AJo2782306 for ; Mon, 10 Sep 2001 15:50:02 -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 f8AJnwqN029384; Mon, 10 Sep 2001 14:49:58 -0500 (CDT) Received: (from ler@localhost) by lerami.lerctr.org (8.12.0/8.12.0/Submit) id f8AJnwCk029383; Mon, 10 Sep 2001 19:49:58 GMT Date: Mon, 10 Sep 2001 14:49:58 -0500 From: Larry Rosenman To: Jeff Barrett Cc: pgsql-sql@postgresql.org Subject: Re: calling a shell script from pl/pgsql Message-ID: <20010910144958.B26527@lerami.lerctr.org> References: <9nip2p$1s5o$1@news.tht.net> <9nj3od$1u4c$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9nj3od$1u4c$1@news.tht.net> User-Agent: Mutt/1.3.22.1i X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200109/44 X-Sequence-Number: 4690 * Jeff Barrett [010910 14:48]: > Thanks for the suggestions. > > I am running 7.1.2 and going to 7.1.3 soon. > > If I use pl/tclu or pl/perlu I can call this executable from within the > code? > > I have a signifigant limitation, I cannot duplicate the action of the > programs I want to call in a program I write within postgres, I need to call > the executable (In this one case it is a shell script but I have others > where it is a binary). > > I cannot find the pl/sh module. The google links that came up brought me to > pages that no longer exist on postgresql.org. I will have to look around > some more. I've reported the missing pages to the postgresql.org webmaster. > > Thanks for the advice... great help! > > Jeff Barrett > > "Jeff Barrett" wrote in message > news:9nip2p$1s5o$1@news.tht.net... > > 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. > > > > Thanks, > > > > Jeff Barrett > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- 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