2 Jun
2000
2 Jun
'00
3:45 a.m.
Cary O'Brien wrote:
Ian Sparks wrote:
Had a thought that I wanted to share.
Interbase has a feature known as "event alerts". In a trigger you can post "events" which are just fixed data strings e.g. "DataAdded" or "Insert_tblUsers".
PostgreSQL has them too.
It's not (afaik) supported by DB-API, but could be used in a DA that talks to some lower level API.
They are supported by the TCL interface that comes with PostgreSQL (src/interfaces/libpgtcl in the PostgreSQL source tree) if you are looking for examples of how they work. (Search for listen and notify in pgtclCmds.c
The lower level python interfaces (_pg, pg) support them too. --------- Hannu