> My specific question is whether any system actually collects
> potential conflicts and analyzes them at commit time rather
> than recognizing the conflict on update and resolving it by
> requiring the second concurrent transaction trying to update
> or delete a row to wait for the outcome of the first transaction?

Not sure I understand the question completely, but wouldn't a DBMS that allows deferred constraints need to do exactly that?

Thomas