> An insert - Can this give me a deadlock ?

Transaction A inserts row with PK=1.

Transaction B inserts row with PK=2.

Transaction A tries to insert row with PK=2 - because PK=2
is already inserted but not committed by transaction B, tr. A waits ...

Transaction B tries to insert row with PK=1 - because PK=1
is already inserted but not committed by transaction A, tr. B waits ...

... deadlock


Ivan