Subject Re: [ib-support] Deadlock and wait
Author Robert F. Tulloch
HI:

> 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? If 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???