Re: Trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger
Date
Msg-id 29150.1066915819@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trigger  (Peter Childs <blue.dragon@blueyonder.co.uk>)
List pgsql-general
Peter Childs <blue.dragon@blueyonder.co.uk> writes:
>     Background, we are trying to get the database to tell clients when
> records get updated, deleted or inserted so that they can update there
> on-screen displays without having to query the database every couple of
> seconds which would put an unnessary strain on the database.

Use LISTEN/NOTIFY.

            regards, tom lane

pgsql-general by date:

Previous
From: Ashwin Kutty
Date:
Subject: Setting up DSPACE for Postgres access
Next
From: Alvaro Herrera
Date:
Subject: Re: database files