April 3rd, 2012, 05:41 AM
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...
CREATE TRIGGER exsportTrigger
AFTER INSERT ON tbl_export
FOR EACH ROW
EXECUTE PROCEDURE do_export();
April 3rd, 2012, 05:56 AM
No, not possible.
Originally Posted by kossmoss
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.