After Insert Trigger vs. Integrity Constraint check
451062Sep 10 2007 — edited Sep 10 2007Hi all,
I have following Problem:
I´ve created a after insert trigger for each row to log the inserted data details on a mapping table. When I try to insert "wrong data" to the mapping table, I get a integrity constraint violated - parent key not found error message. The record will not be inserted into mapping table, but the trigger will be fired with "wrong data".
I thought, a after trigger will be fired after constraint check and after sucessful inserting to the table.
Have anybody a idea? Am I wrong?
Many Thanks