Subject Deadlock, Insert question
Author Michael Vilhelmsen

An insert - Can this give me a deadlock ?

Sometimes I some of my clients gets these deadlocks.
As far as I have looked into this, it happens on a insert.

This table I insert into has no foreign keys, and only 1 primary key
(which is an integer assigned by a trigger BEFORE INSERT using a

The table has some 7 index.

Besides the above trigger, there is another trigger AFTER INSERT, that
in some cases makes another insert into another table.
This trigger is called every 10th time an insert in the first table is