On Wed, 27 Nov 2002, Joshua Daniel Franklin wrote:
> Is there a quick SQL way to check if a certain table
> (or row) is locked?
>
> I see that an UPDATE will just block until the previous
> lock is removed.
I think this question I asked earlier before reading more
is a misunderstanding of how SQL works. Locking is not to
prevent others from being able to modify rows before seeing
how they have changed, but to enforce an ordering.