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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to