pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)  latest in thread

Message-ID: <20010910144958.B26527@lerami.lerctr.org>
Permalink:  ../20010910144958.B26527@lerami.lerctr.org/
Also on:    postgresql.org/message-id/20010910144958.B26527@lerami.lerctr.org

 · 

reply

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