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