pgsql: Fix table lock levels for REINDEX INDEX CONCURRENTLY

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: Fix table lock levels for REINDEX INDEX CONCURRENTLY
Дата
Msg-id E1hOLkj-0004oE-IV@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix table lock levels for REINDEX INDEX CONCURRENTLY

REINDEX CONCURRENTLY locks tables with ShareUpdateExclusiveLock rather
than the ShareLock used by a plain REINDEX.  However,
RangeVarCallbackForReindexIndex() was not updated for that and still
used the ShareLock only.  This would lead to lock upgrades later,
leading to possible deadlocks.

Reported-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://www.postgresql.org/message-id/flat/20190430151735.wi52sxjvxsjvaxxt%40alap3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/add85ead4ab969c1e31d64f4476c2335856f4aa9

Modified Files
--------------
src/backend/commands/indexcmds.c | 45 +++++++++++++++++++++++++++++-----------
1 file changed, 33 insertions(+), 12 deletions(-)


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Probe only 127.0.0.1 when looking for ports on Unix.
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: pgsql: docs: fist draft version of the PG 12 release notes