Re: calling a shell script from pl/pgsql

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jeff Barrett <jbarrett(at)familynetwork(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: calling a shell script from pl/pgsql
Date: 2001-09-10 17:22:35
Message-ID: Pine.BSF.4.21.0109101018210.15401-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Larry Rosenman 2001-09-10 17:51:55 Re: calling a shell script from pl/pgsql
Previous Message Stephan Szabo 2001-09-10 17:18:13 Re: row level locking?