Table vs. row level locks confusion

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Table vs. row level locks confusion
Дата
Msg-id Pine.LNX.4.30.0109041255070.828-100000@peter.localdomain
обсуждение исходный текст
Ответы Re: Table vs. row level locks confusion
Список pgsql-hackers
The following section

http://www.ca.postgresql.org/devel-corner/docs/postgres/locking-tables.html

titled "Locking and Tables", has two subsections, "Table-level locks" and
"Row-level locks".  Under table-level locks we find lock names such as
RowShareLock and RowExclusiveLock -- are those table-level locks?  Under
row-level locks we find no specific lock names mentioned.

What I wonder is, if I do

BEGIN;
LOCK table1 IN ROW EXCLUSIVE MODE;

what do I lock?  The table?  A row?  Which row?

Clarification appreciated.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Bytea/Base64 encoders for libpq - interested?
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: ODBC TODO list is way out of date