Skip site navigation (1) Skip section navigation (2)

Asynchronos notifications to clients on table changes

From: Vincent AE Scott <pgsql-novice(at)codex(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Asynchronos notifications to clients on table changes
Date: 2001-12-07 13:30:39
Message-ID: 20011207133039.C1438@majestic.ukshells.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
What would be a reliable way for a client accessing postgres to be
informed asynchronosly of inserts/updates/deletes to a table?  I'm
thinking of something that has fairly fine grained control over what it
gets notified of.  Something like a client registering (somewhere) a
select statement, and when a matching row changes to be informed about
it.

I guess this would require some external program, and possibly
programmed trigger modules in the database?

Is this even theoretically possible?  Or would the overhead under heavy
loads completely kill the database?


-- 

PGP key:  http://codex.net/pgp/pgp.asc

Responses

pgsql-novice by date

Next:From: Jason EarlDate: 2001-12-07 17:29:48
Subject: Re: Number of days in a month
Previous:From: Oliver WalterDate: 2001-12-07 13:20:02
Subject: pg_ctl stop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group