Maybe an aditional check for trigger creating ?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Maybe an aditional check for trigger creating ?

PegoraroF10
If I create a function and trigger but not define transition table, it creates but gives me an error when I insert a record on it. I think de default values for transition tables were old and new.
create trigger Var_Test after insert or update or delete on VarTable for each statement execute procedure vartest();

But if I try to define transition tables it gives me an error when creating that trigger.
create trigger Var_Test after insert or update or delete on sys_Var referencing old table as old_table new table as new_table for each statement execute procedure testavar();


So, wouldn´t be good to have a check before trigger is created just to see if that trigger is statement so it cannot have more than one event and needs to have transition tables defined, what you think ?