Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
On Friday 07 April 2006 03:52 pm, Yudie Pg saith: > Help! > Try to install plperl > ./createlang plperl mydb > > createlang: language installation failed: ERROR: could not access file > "$libdir/plperl": No such file or directory Do you have the Perl module on your machine? If not, you can get

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
Help! Try to install plperl ./createlang plperl mydb   createlang: language installation failed: ERROR:  could not access file "$libdir/plperl": No such file or directory          

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
Reminds me of an old Star Trek - Next Generation episode. They were stuck in a time loop reliving the same series of events over and over. They had to leave themselves a clue so they could figure it out next time around. Maybe your post is it ;o) On Friday 07 April 2006 02:12 pm, Scott Marlowe

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 12:38, Terry Lee Tucker wrote: > On Friday 07 April 2006 01:32 pm, Yudie Pg saith: > > Back to my original question where is it possible to run a command line > > from a function? > > From an earlier post: > "Note that plpgsql cannot run external programs on purpose. It's a

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
On Friday 07 April 2006 01:32 pm, Yudie Pg saith: > Back to my original question where is it possible to run a command line > from a function? From an earlier post: "Note that plpgsql cannot run external programs on purpose. It's a security and safety issue." ---(end of b

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
Back to my original question where is it possible to run a command line from a function?

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Tony Caduto
Yudie Pg wrote: I'm running postgresql 7.4.1. is it can't really be used for trigger function? http://www.postgresql.org/docs/7.4/static/plperl-missing.html That is true, but you can call a plperl function from a plpgsql trigger function. Wouldn't that work? -- Tony Caduto

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 10:42, Yudie Pg wrote: > > > I'm running postgresql 7.4.1. is it can't really be used for trigger > function? > > http://www.postgresql.org/docs/7.4/static/plperl-missing.html > Quick followup, the latest plPHP does not work on Postgresql versions < 8.0. So yo

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 10:42, Yudie Pg wrote: > > > I'm running postgresql 7.4.1. is it can't really be used for trigger > function? > > http://www.postgresql.org/docs/7.4/static/plperl-missing.html > Two points: 1: Upgrade to 7.4.12 (or whatever the latest version is) immediately.

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
  I'm running postgresql 7.4.1. is it can't really be used for trigger function?   http://www.postgresql.org/docs/7.4/static/plperl-missing.html          

Re: [GENERAL] Running Command Line From Trigger?

2006-04-06 Thread Scott Marlowe
On Thu, 2006-04-06 at 14:48, Yudie Pg wrote: > I want to execute a command line from trigger function. > The reason is I want to execute my perl script from stored procedure. > Why not just install perl as a procedural language? It's one of a dozen or more available to you. Then you can write

Re: [GENERAL] Running Command Line From Trigger?

2006-04-06 Thread Terry Lee Tucker
On Thursday 06 April 2006 03:48 pm, Yudie Pg saith: > I want to execute a command line from trigger function. > The reason is I want to execute my perl script from stored procedure. > > any idea? > > > Yudie Yudie, You might want to write your perl script as a trusted perl funcion and call from

[GENERAL] Running Command Line From Trigger?

2006-04-06 Thread Yudie Pg
I want to execute a command line from trigger function. The reason is I want to execute my perl script from stored procedure.   any idea?     Yudie