| From: | Fernando Nasser <fnasser(at)redhat(dot)com> |
|---|---|
| To: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: functions, shell script |
| Date: | 2001-11-06 17:01:25 |
| Message-ID: | 3BE81765.A46EF400@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Nickel | 2001-11-06 17:08:15 | Re: copy command with PSQL |
| Previous Message | bpalmer | 2001-11-06 16:49:41 | Re: Howto change column length |