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

Re: integration of fulltext search in bytea/docs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: Radek Novotný <radek(dot)novotny(at)mediawork(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: integration of fulltext search in bytea/docs
Date: 2009-07-30 14:08:23
Message-ID: 12207.1248962903@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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  
> commands.

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 LaneDate: 2009-07-30 14:20:48
Subject: Re: Clients disconnect but query still runs
Previous:From: Jennifer TreyDate: 2009-07-30 14:01:16
Subject: Re: How do I run PG Tuning Wizard on Linux?

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