2 Jun
2000
2 Jun
'00
3:44 a.m.
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