Re: EXTPROC External Procedure - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: EXTPROC External Procedure
Date
Msg-id 20050209190021.GA13746@dcc.uchile.cl
Whole thread Raw
In response to EXTPROC External Procedure  (Roy Souther <roy@silicontao.com>)
List pgsql-general
On Wed, Feb 09, 2005 at 11:29:21AM -0700, Roy Souther wrote:

> I need to be able to run a program when some data is requested from the
> database. Some query will do a SELECT on a known table and I need to have
> some event trigger that makes a call to generate a small XML file and then
> post it to a web server, get a reply back and then update a local table with
> the information it received.

You may be able to use a pl/perlu (untrusted perl) function to do this.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"No reniegues de lo que alguna vez creíste"

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: EXTPROC External Procedure
Next
From: Alvaro Herrera
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output