To leave the database in a consistent state.

If the trigger detect an error a rollback / undo of the 'insert' is automatically performed.

Read about Codd and his 10 relational commandments.