| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
| Cc: | "Ertel, Steve" <Steve(dot)Ertel(at)infimatic(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: postgres launch os applications |
| Date: | 2008-10-07 17:38:50 |
| Message-ID: | 396486430810071038vf551ca5xb5178425e22a918@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Oct 7, 2008 at 10:34 AM, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
> You cannot do this with any "trusted" language (which includes
> pg/plsql). However, you can use any of the untrusted languages like
> pl/python, pl/perl, pl/java, pl/tcl, etc. Of course, each of those
> languages has its own specifics dealing with starting executables.
To add to this point. IIRC, these languages are untrusted because
they can trigger events outside the database that cannot be rolled
back in the event of an error.
Another option to might work is using the list notify mechanism.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2008-10-07 17:39:46 | Re: postgres launch os applications |
| Previous Message | Sean Davis | 2008-10-07 17:34:21 | Re: postgres launch os applications |