Posted by Joe Weinstein on 02/04/06 18:42

Joe Weinstein wrote:

> Hi.
>
> create table joe(c1 integer not null, c2 integer not null)
>
> Two sessions:
>
> Session 1:
> BEGIN TRAN
> insert into joe (c1,c2) values (1,2)
>
>
> Session 2:
> BEGIN TRAN
> insert into joe (c1,c2) values (3,4)
>
> Session 1:
> select * from joe
>
> Session 2:
> select * from joe
>
> One of the sessions gets a deadlock victim message.
> thanks,
> Joe

PS: This doesn't occur with Sybase, which is fairly closely
related...
Joe

• Next in forum: Re: Views vs Stored Procedures, whats the difference?
• Prev in forum: Re: Views vs Stored Procedures, whats the difference?
• Thread view: Re: can you tell me why this causes a deadlock?

[Reply to this message]