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