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

Re: postgres launch os applications

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres launch os applications
Date: 2008-10-07 17:39:46
Message-ID: 20081007173946.GA7634@tux (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Ertel, Steve <Steve(dot)Ertel(at)infimatic(dot)com> schrieb:

> I am trying to start an OS executable every time that a table is updated.  I
> know that I should create a trigger on the table, but how do I launch the OS
> executable.  I have a background in sql server.  In it we would use something
> like xsp_execute().  I am looking for the equivalent function call in Postgres.

Write a trigger-function using an untrusted language like pl/perlU. You
can call arbitray commands within an untrusted language. With the
regular trusted languages such plpgsql or so you can't call external

Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

In response to

pgsql-novice by date

Next:From: mrbusecoDate: 2008-10-07 18:07:06
Subject: Re: postgres launch os applications
Previous:From: Richard BroersmaDate: 2008-10-07 17:38:50
Subject: Re: postgres launch os applications

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