Post reply

At what point are commits done for triggers

  • July 26, 2005 at 6:32 am

    #363256

    We have multiple triggers on a single table.  We had estiblished the firing order of for the these triggers.  Each trigger does some updates to various tables in the database.  At what point are the updates committed?  After each trigger completion or after all trigger completion?

  • July 26, 2005 at 1:33 pm

    #577291

    After ALL are completed!!

     


    * Noel

  • July 27, 2005 at 7:25 am

    #577523

    Triggers are commited right after execution...which means if you have 3 triggers doing inserts, after the first and before the next is triggered, it's commited.

    If I may suggest, if all triggers are triggered off of one table within the same action (ie. INSTEAD OF), why not group them as one trigger?

    Hope this helps.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply