Add further details to ROW SHARE table level lock modes section

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Add further details to ROW SHARE table level lock modes section
Дата
Msg-id 164908765512.682.17348032020747341013@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Add further details to ROW SHARE table level lock modes section  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/explicit-locking.html
Description:

The ROW SHARE table level lock modes section currently states:
```
Conflicts with the EXCLUSIVE and ACCESS EXCLUSIVE lock modes.

The SELECT FOR UPDATE and SELECT FOR SHARE commands acquire a lock of this
mode on the target table(s) (in addition to ACCESS SHARE locks on any other
tables that are referenced but not selected FOR UPDATE/FOR SHARE).
```
I propose that it would be useful to explicitly state that `SELECT FOR KEY
SHARE` AND `SELECT FOR NO KEY UPDATE` commands also acquire the ROW SHARE
table level lock on target table(s). That is:
```
Conflicts with the EXCLUSIVE and ACCESS EXCLUSIVE lock modes.

The SELECT FOR UPDATE, SELECT FOR NO KEY UPDATE,  SELECT FOR SHARE, and
SELECT FOR KEY SHARE commands acquire a lock of this mode on the target
table(s) (in addition to ACCESS SHARE locks on any other tables that are
referenced but not selected FOR UPDATE/FOR SHARE).
```

Thank you for your time.

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

Предыдущее
От: Kouber Saparev
Дата:
Сообщение: Re: Indexes documentation bug
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Improve documentation for pg_upgrade, standbys and rsync