On Tue, Oct 7, 2008 at 1:38 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Tue, Oct 7, 2008 at 10:34 AM, Sean Davis <sdavis2@mail.nih.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.
This is definitely the better option.
Sean