pl/sh (was Re: calling a shell script from pl/pgsql)

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Jeff Barrett <jbarrett(at)familynetwork(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: pl/sh (was Re: calling a shell script from pl/pgsql)
Date: 2001-09-10 18:17:19
Message-ID: Pine.BSO.4.10.10109101415580.17071-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 10 Sep 2001, Stephan Szabo wrote:

> 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.
Or pl/perlu! (Sorry, had to say it).

Actually, I remember that Jan once mentioned something about pl/SH. I
don't know what's the status of it?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-09-10 18:19:13 Re: pl/sh (was Re: calling a shell script from pl/pgsql)
Previous Message Larry Rosenman 2001-09-10 17:51:55 Re: calling a shell script from pl/pgsql