Re: need help about deadlock by insert statements

How about:
user A

        insert into T values (primary key = X) user B

        insert into T values (primary key = Y)         

user A

        insert into T values (primary key = Y) user B

        insert into T values (primary key = X)         

This would give a deadlock.
User A would be waiting for B either to commit its first insert so that A could issue a PK error, or to rollback so that A could do an insert. Same holds for user B.

Jonathan Lewis Received on Thu Aug 20 1998 - 08:37:17 CDT