I would like to know if it is posible to ensure block a row when is selected and then not to be able to be selected from another sesión.
I tried xlock, rowloxk but sometimes the second sesión is able to select the row. I can't reproduce this behaviours always, but sometimes happend.
By the moment, the only way to ensure that is doing a fake updating of the row inside a transaction. But this is an extra cost for the database and I would lie to know if there is any other option to ensure the block of the row when is selected.
Thanks.
Go to the complete details ...