Re: [HACKERS] LOCK TABLE statement

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] LOCK TABLE statement
Дата
Msg-id 199804221428.KAA24050@candle.pha.pa.us
обсуждение исходный текст
Ответ на LOCK TABLE statement  ("Jose' Soares Da Silva" <sferac@proxy.bazzanese.com>)
Список pgsql-hackers
>
>
> 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)

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Göran Thyni"
Дата:
Сообщение: Re: [HACKERS] Re: Proposal for async support in libpq
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Safe/Fast I/O ...