Skip site navigation (1) Skip section navigation (2)

Re: postgres launch os applications

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2008-10-07 17:39:46
Subject: Re: postgres launch os applications
Previous:From: Sean DavisDate: 2008-10-07 17:34:21
Subject: Re: postgres launch os applications

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group