Subject | Trigger question |
---|---|
Author | Nico Callewaert |
Post date | 2001-06-18T13:06:55Z |
Hi,
I'm wondering if a trigger can cause a deadlock ? I guess triggers are
out of transaction control ? Example : User X is inserting a record in
table A, a after insert trigger is updating a record in table B, and user Y
is busy changing that same record from table B --> could that situation
cause a deadlock ?
Thank you, Nico Callewaert
I'm wondering if a trigger can cause a deadlock ? I guess triggers are
out of transaction control ? Example : User X is inserting a record in
table A, a after insert trigger is updating a record in table B, and user Y
is busy changing that same record from table B --> could that situation
cause a deadlock ?
Thank you, Nico Callewaert