great discussion...on rollback.

what about the scenario...where

* one trigger does updates other tables

* another trigger does updates to some other tables

* what will happen if there is rollback in one of...