On Mon, 30 Dec 2002, Andy Kriger wrote:
> It doesn't lock the row from being read. I want to make sure the row cannot
> be read until I have done my read and updated if necessary. LOCK TABLE does
> that but also prevents other rows from being read which is a bit overzealous
> for my taste (the app is small so it's probably not a big deal in this case,
> but I can see in future possibilities how it would be).
You do realize of course, that with MVCC and serializable transactions,
the readers can't see what you're writing. i.e. they won't see any of
your changes until a commit.
