Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
> On Jul 30, 2009, at 9:09 , Radek Novotn wrote:
>> Is there possible to create pg trigger that runs shell script?
> Yes. You can use an untrusted language such as pl/perlu to run system
The fact that you can do it doesn't make it a good idea ...
If you do this, you'll need to consider what happens if the database
transaction rolls back after calling your trigger. The effects in the
filesystem are still there, but the effects in the database aren't.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2009-07-30 14:20:48|
|Subject: Re: Clients disconnect but query still runs |
|Previous:||From: Jennifer Trey||Date: 2009-07-30 14:01:16|
|Subject: Re: How do I run PG Tuning Wizard on Linux?|