Re: [HACKERS] LOCK TABLE statement

Started by Bruce Momjianabout 28 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Hi, all

Is the following sentence true ?

* LOCK TABLE statement don't allows read access to locked tables by
the other users.
If another user try to SELECT a locked table, he must attend
until the locked table is released.

I have heard about another syntax of LOCK TABLE that allows read access
to locked tables, on v6.3.2.
Is it true or I've dream ?

No, perhaps in 6.4. However, any select from a table does it.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)