Re: [SQL] calling a shell script from pl/pgsql

2001-09-11 Thread Jan Wieck
Jeff Barrett wrote: > 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 w

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

2001-09-10 Thread Peter Eisentraut
Alex Pilosov writes: > Actually, I remember that Jan once mentioned something about pl/SH. I > don't know what's the status of it? http://webmail.postgresql.org/~petere/plsh.html It's a toy project of mine. It's usable, but there are probably some portability problems. -- Peter Eisentraut

Re: [SQL] calling a shell script from pl/pgsql

2001-09-10 Thread Larry Rosenman
* Jeff Barrett <[EMAIL PROTECTED]> [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 > progra

Re: [SQL] calling a shell script from pl/pgsql

2001-09-10 Thread Jeff Barrett
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 cal

Re: [SQL] calling a shell script from pl/pgsql

2001-09-10 Thread clayton cottingham
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

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

2001-09-10 Thread Alex Pilosov
On Mon, 10 Sep 2001, Stephan Szabo wrote: > > On Mon, 10 Sep 2001, Alex Pilosov wrote: > > > 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

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

2001-09-10 Thread Stephan Szabo
On Mon, 10 Sep 2001, Alex Pilosov wrote: > 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 w

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

2001-09-10 Thread Alex Pilosov
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 th

Re: [SQL] calling a shell script from pl/pgsql

2001-09-10 Thread Larry Rosenman
* Stephan Szabo <[EMAIL PROTECTED]> [010910 12:37]: > 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 wa

Re: [SQL] calling a shell script from pl/pgsql

2001-09-10 Thread Stephan Szabo
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 v

[SQL] calling a shell script from pl/pgsql

2001-09-10 Thread Jeff Barrett
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. Th