Re: Question about DEADLOCK

On Fri, 22 Nov 2002, Savita wrote:

> I wold like to know where to get LOCK manual/reference.

Well, there's the entry for the LOCK command, but I don't think
that's what you want, what exactly are you looking for?


> And what is ther error number it will return when this error will come.Is there
> any work around this.HOw do I avoid this situation.

I don't know of an error number, but the string will will have that
deadlock detected in it. :) As for a workaround, since we don't know
what's causing it, we can't really give you a workaround.

What's the schema of the table you're transferring to and what else
was going on in the server at the time you got the deadlock?  I'd
guess it was a foreign key, but that only applies if you've got
foreign keys, for example.