From: Larry Rosenman <ler@lerctr.org>
To: Jeff Barrett <jbarrett@familynetwork.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: calling a shell script from pl/pgsql
Date: Mon, 10 Sep 2001 14:49:58 -0500
Message-ID: <20010910144958.B26527@lerami.lerctr.org> (raw)
In-Reply-To: <9nj3od$1u4c$1@news.tht.net>
References: <9nip2p$1s5o$1@news.tht.net>
<9nj3od$1u4c$1@news.tht.net>
* Jeff Barrett <jbarrett@familynetwork.com> [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" <jbarrett@familynetwork.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ler@lerctr.org, jbarrett@familynetwork.com
Subject: Re: calling a shell script from pl/pgsql
In-Reply-To: <20010910144958.B26527@lerami.lerctr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox