Re: SELECT FOR UPDATE problem

[Xan Charbonnet]

I just spent quite a while trying to figure this out. It turns out the documentation is wrong. The documentation says that SELECT FOR UPDATE prevents other sessions from accessing the rows for reading or writing.

What it actually appears to do is prevent other sessions from acquiring a lock on the rows.

So it prevents reading if the second thread tries a SELECT LOCK IN SHARE MODE or a SELECT FOR UPDATE (or an UPDATE of course), but allows a bare SELECT to go through.