If I lock a table with write, will another connection be able to read from
that table while it's locked? I hope not.

"Jim Michaels" <NOSPAMFORjmichae3@yahoo.com> wrote in message
news:uo6dnTOfVoLP2tHZnZ2dnUVZ_t6dnZ2d@comcast.com. ..
> If I lock a table with write, will another connection be able to read from
> that table while it's locked? I hope not.
>

I just tried it, I think reads are allowed. ugh. this race condition is
causing grief. Am I technically wrong? I couldn't find anything specific
about this situation in the manual (unfortunately). and there's no way to
lock a table for both read AND write.