Re: Calling external program from trigger - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Calling external program from trigger
Date
Msg-id 28911.1053442991@sss.pgh.pa.us
Whole thread Raw
In response to Calling external program from trigger  (Kaare Rasmussen <kar@kakidata.dk>)
List pgsql-hackers
Kaare Rasmussen <kar@kakidata.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


pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: System triggers
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Interessting problem