Re: Runnning operating system commands from an SPL

Thanks Adreas, I understand now. Like I mentioned I have several pgSQL
stored procedures which access the OS and need to be rewritten in perlu.

The problem is I have no knowledge of perl at all. Can you direct me to a
quick and easy to get to grips with resource online?
Thanks again

Atif

--
Words of Wisdom
=============

George Bernard Shaw, the British playwright said:

“The world is in dire need of a man with the mind of Muhammad; religious
people in the Middle Ages, due to their ignorance and prejudice, had
pictured him in a very dark way as they used to consider him the enemy of
Christianity. But after looking into the story of this man I found it to be
an amazing and a miraculous one and I came to the conclusion that he was
never an enemy of Christianity, and must be called instead the saviour of
humanity. In my opinion, if he was to be given control over the world today,
he would solve our problems and secure the peace and happiness for which the
world is longing.”

On 17 June 2010 16:37, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:

> Atif Jung <atifjung(at)gmail(dot)com> wrote:
>
> > Sorry I don't understand. I am porting over some stored procedures from
> > INFORMIX to POSTGRES. Some seem to port over OK, but the first problem I
> am
> > encountering is the lack of SYSTEM command in POSTGRES.
>
> That's right.
>
> >
> > I don't understand what you mean by using an untrusted programming
> language.
>
> We have several internal languages, for instance plpgsql, plperl and
> plperlu. Some of them are so called 'trusted languages', for instance
> plpgsql. With a trusted language you can't operate outside the pg-system
> (no access to the underlaying operating system), with untrusted
> languages like plperlu you have access.
>
>
> > The stored procedure is written in PL/pgSQL, are you suggesting to
> rewrite it
> > in PERL, excuse me for my ignorance.
>
> Right, if you really needs that. But you should reconsider your idea,
> see Tom's answer.
>
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>