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
