> On Dec 2, 2015, at 6:35 AM, Tim Ward t...@telensa.com [firebird-support] > <firebird-support@yahoogroups.com> 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