[Zope] Interbase / Cacheing - A thought

Hannu Krosing hannu@tm.ee
Fri, 02 Jun 2000 06:44:31 +0300


Ian Sparks wrote:
> 
> Hannu,
> 
> Does PostgresSQL allow you to have dynamic events? By this I mean can you do
> things like :
> 
> PostEvent "Update_tblUsers_Record_" + new.RecordID;

No, but it may change sometime (possibly soon) as PostgreSQL is an
open-source
product ...

> I believe that in Interbase the events are compiled into the trigger, not
> interpreted at Runtime so you can't have an Interbase event alert you to a
> change in a particular record, only that a change has occurred on a table.

The same is true for postgrSQL, only the syntax is LISTEN/NOTIFY.

--------
Hannu