> On Dec 2, 2015, at 6:35 AM, Tim Ward [email protected] [firebird-support] > <[email protected]> wrote: > > What about if two concurrent transactions are both trying to *delete* > the *same* record at once? - from the point of the view of the user's > objectives there's no reason why this shouldn't work, as either way the > record is going to end up deleted, which is what the user wants, but > would I be right in guessing that Firebird isn't that clever, and that > deadlocks are possible in this scenario?
It's not nearly that simple. What would happen if one of those transactions rolled back? Good luck, Ann
