LOCK TABLES on compressed tables...

[Paul Cadach]

Hi,

I'm uses write locks to prevent other people to write to table when I'm
updates it. When updating I need to select some additional values from other
table, so I must lock it too. But because table is compressed (aka
read-only), I can't lock it with write lock. Why?

As I understand, write lock delays any writes to locked table performed by
other connections until a table is unlocked. In case with compressed
(read-only) table, it can be treaded as 'locked for write' all times when
LOCK TABLE ... WRITE issued.


WBR,
Paul.