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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-07-30 14:20:48 Re: Clients disconnect but query still runs
Previous Message Jennifer Trey 2009-07-30 14:01:16 Re: How do I run PG Tuning Wizard on Linux?