|Subject||Re: [ib-support] Deadlock and wait|
|Author||Ann W. Harrison|
>I wrote:At 08:44 PM 7/26/2001 -0400, Robert F. Tulloch wrote:
> > If transaction A attempts to update a row that transaction B has already
> > changed, the WAIT option causes A to wait for B to end before reporting
> > an error to A. If B rolls back, A succeeds. If B commits, A gets a
> > Deadlock - update conflict error.
> Don't understand this. Why is it an deadlock if B has committed? IfIt's a deadlock because an update was committed by a concurrent transaction.
> deadlock in this
>case is correct then if A closes then reopens A can update, right? So why
>can A update
>1 sec after B commits or .001 sec after B commits???
A can not see B's changes (consistency, that hobgoblin of my mind), so A
can't overwrite them.
We have answers.