Hey folks: I want to clarify a few things about locks on updates:
1- can two processes update the same table if they are updating different
rows?
2- in the event of two processes trying to update the same row, does this
always result in a deadlock?
3- is there a way to create a system whereby potentially concurrent
processes can update the same row in a given table, can the server be made
to queue those updates, etc?
Is it just a no-go to try and have a situation where concurrent processes
are trying to update the same record?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>