Re: Excute comnands OS from plpgsql

On Tuesday 14 October 2003 17:15, Richard Huxton wrote:
> On Tuesday 14 October 2003 16:38, Edwin Quijada wrote:

> How can I use NOtify to do this?

Please make sure you reply to the list too.

In your daemon you do something like: "LISTEN signal1", and in a trigger (say)
you issue "NOTIFY signal1". Your daemon will receive an asynchronoums message
"signal1" and you can then check the relevant tables for
updates/deletions/whatever signal1 means.

In practice, I usually don't care about responding that quickly, and just have
a cron job start up a script every 5 mins to check a "pending_jobs" table.

--
Richard Huxton
Archonet Ltd