Evitar que otro usuario edite el mismo registro

[Italico76]

Investiga LOCK IN SHARE MODE... que segun leo rapido... es para bloquear el REGISTRO

SELECT * FROM parent WHERE NAME = 'Jones' LOCK IN SHARE MODE;

the description:

Any transaction that tries to read or write to the applicable row in the PARENT table waits until you are finished...