Starting a daemon process on INSERT

From: "P(dot)V(dot) Subramanian" <pvsmian(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Starting a daemon process on INSERT
Date: 2001-08-16 18:39:49
Message-ID: F260uYDlrjbudzxxfYX000096ec@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message travep 2001-08-16 21:55:58 Queries seem to lock up shell session
Previous Message John Burski 2001-08-16 15:03:39 Re: Opaque data type