| Subject | Re[2]: [Firebird-Architect] Re: [IB-Architect] Rebuilding foreign keys system indexes |
|---|---|
| Author | Nickolay Samofatov |
| Post date | 2003-04-22T12:21:12Z |
Hi, Jim,
from row triggers. To do some useful work you need to create temporary
table in PRE- statement trigger, fill it with work you want to do in
row triggers and actually do the work in POST- statement trigger.
All versions of Interbase and Firebird do better way. :)
They allow access to a table for which trigger is fired from row
triggers and silently or after BUGCHECK(291) corrupt database if you
try to modify a record for which PRE- trigger is fired.
Alex tries to fix it for Firebird 1.5 now.
> At 10:02 AM 4/22/03 +0200, Martijn Tonies wrote:Simple. Oracle forbids access to a table for which trigger is fired
>>Which reminds me - Oracle also has triggers that fire after each statement
>>instead of each row... Also quite a nice addition :)
> How are used? I've never understood what they're good for.
from row triggers. To do some useful work you need to create temporary
table in PRE- statement trigger, fill it with work you want to do in
row triggers and actually do the work in POST- statement trigger.
All versions of Interbase and Firebird do better way. :)
They allow access to a table for which trigger is fired from row
triggers and silently or after BUGCHECK(291) corrupt database if you
try to modify a record for which PRE- trigger is fired.
Alex tries to fix it for Firebird 1.5 now.
> Jim StarkeyNickolay Samofatov