Re: locking problem...?

[Jim Faucette]

elble@stripped wrote:
> 
> hello, Sinisa.
> 
> BTW, this works:
> 
> client #1.) lock tables foobar read; ('READ' lock acquired)
> client #2.) update low_priority foobar set this=1; (pending 'WRITE' lock, blocked)
> client #3.) select * from foobar; (this doesn't block now!!!)
> 
> i see now, it doesn't really have anything to do with locking per se. ;-)
> 
> but, am i the only person who has this problem?
> 

In general read and write locking is not intuitive. Whether at the
system or application level it usually takes time and effort to
understand get used to the 'logic'.

  jim...