From: Jeff Barrett <jbarrett@familynetwork.com>
To: pgsql-sql@postgresql.org
Subject: Re: calling a shell script from pl/pgsql
Date: Mon, 10 Sep 2001 15:15:50 -0400
Message-ID: <9nj3od$1u4c$1@news.tht.net> (raw)
References: <9nip2p$1s5o$1@news.tht.net>
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.
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
>
>
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: jbarrett@familynetwork.com
Subject: Re: calling a shell script from pl/pgsql
In-Reply-To: <9nj3od$1u4c$1@news.tht.net>
* 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