Subject Re: [firebird-support] Deleting records and deadlocks
Author Ann Harrison
> On Dec 2, 2015, at 6:35 AM, Tim Ward tdw@... [firebird-support] <> 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,