An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
edition表上的after - insert触发器并非很有用,因为它只能截获其status值为start的记录行。
If one or more insert triggers are defined on a table, each insert will result in the execution of the actions prescribed in the trigger definition.
如果在一个表上定义了一个或多个进行insert操作的触发器,那么每次的insert都将引起触发器定义中的动作的执行。
A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值,这样就不会违反约束。
应用推荐