#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    Commit data while trigger is executing


    I have AFTER INSERT trigger that have a lot off job to do.
    I want that inserted row is commited in database and is accesible to others while trigger is executing.
    Is it possible?
    Know inserted row is commited after trigger ends his excecution...

    My code:
    CREATE TRIGGER exsportTrigger
    AFTER INSERT ON tbl_export
    FOR EACH ROW
    EXECUTE PROCEDURE do_export();
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    Originally Posted by kossmoss
    I have AFTER INSERT trigger that have a lot off job to do.
    I want that inserted row is commited in database and is accesible to others while trigger is executing.
    Is it possible?
    No, not possible.
    Anything done in the trigger is committed within the scope of the surrounding transaction, i.e. the process that ran the statement which fired the trigger.

IMN logo majestic logo threadwatch logo seochat tools logo