Re: Calling external program from trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kar(at)kakidata(dot)dk
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Calling external program from trigger
Date: 2003-05-20 15:03:11
Message-ID: 28911.1053442991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kaare Rasmussen <kar(at)kakidata(dot)dk> writes:
> I would like to notify a server whenever a certain table is updated.

What do you mean by "notify" exactly?

Perhaps you could have a background job that remains always connected to
the database, but sleeps waiting for a NOTIFY to arrive. A rule like
"ON UPDATE TO foo DO NOTIFY foo_changed" would serve to awaken it.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2003-05-20 15:07:17 Re: Interessting problem
Previous Message Doug McNaught 2003-05-20 15:02:29 Re: System triggers