Re: listen/notify

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tomas B(dot) Winkler" <tomasw(at)cs(dot)huji(dot)ac(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: listen/notify
Date: 2000-07-12 18:09:07
Message-ID: 24211.963425347@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tomas B. Winkler" <tomasw(at)cs(dot)huji(dot)ac(dot)il> writes:
> Could someone, please give me a little example on how to use listen/notify
> mechanism. Or at least point me to some more legible documentation.
> What I particulary need is that my frontend application is notified on
> update/insert in a table.

Make an ON INSERT OR UPDATE trigger that executes the NOTIFY.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message J.R. Belding 2000-07-12 18:13:20 Re: psql and Gnu readline
Previous Message The Hermit Hacker 2000-07-12 18:01:49 Re: Sorry...