Re: functions, shell script

Jean-Michel POURE wrote:
>
> >Can anyone give me an example of postgresql function that will execute a
> >shell script?
> >I will call the function from a postgresql trigger.
>
> You need to create an untrusted language which I never did until now.
> For example, plpgsql functions are trusted, i.e. they cannot access the
> file system.
>
> I would be interested in knowing how to do it.
> Maybe it is possible with plperl or pltcl.
>

PL/TclU is untrusted (note the "U").  I never used it myself and I don't
even know if it is working but maybe you could give it a try...

(please let us know if it worked)

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9