Blocking lock on INSERT trigger
Posted on 2005-03-04
Within a FOR INSERT trigger, I would like to know how to perform an UPDATE on the row which is being inserted without causing a blocking lock to occur.
1) INSERT statement locks table/row
2) trigger fires
3) UPDATE statement in trigger waits for lock to be realeased to perform update on row which inserted
Anyone know how I can make the update possible in the trigger without the block?
Thanks in advance