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.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug