Starting a daemon process on INSERT - Mailing list pgsql-novice

From P.V. Subramanian
Subject Starting a daemon process on INSERT
Date
Msg-id F260uYDlrjbudzxxfYX000096ec@hotmail.com
Whole thread Raw
Responses using the Text::Query perl module with postgresql  (harrold@sage.che.pitt.edu)
List pgsql-novice
Hi all

I am writing an application which needs a daemon process to do some activity
as soon as certain types of records are added.

I don't want the daemon to continuously poll the DB, so I am trying to
create a trigger which would send some kind of signal to this daemon (or
even start a normal executable which terminates after finishing its job).

However I don't seem to be able to accomplish anything trigger driver driven
that would launch another external app. elog notices, SQL queries etc. work
but I want none of these!

Help appreciated.

PVS

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


pgsql-novice by date:

Previous
From: John Burski
Date:
Subject: Re: Opaque data type
Next
From: travep
Date:
Subject: Queries seem to lock up shell session