Обсуждение: pgsql: Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KE

Поиск
Список
Период
Сортировка

pgsql: Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KE

От
Tom Lane
Дата:
Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KEY.

The docs explained that a SHARE ROW EXCLUSIVE lock is needed on the
referenced table, but failed to say the same about the table being
altered.  Since the page says that ACCESS EXCLUSIVE lock is taken
unless otherwise stated, this left readers with the wrong conclusion.

Discussion: https://postgr.es/m/834603375.3470346.1586482852542@mail.yahoo.com

Branch
------
REL_12_STABLE

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

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 21 +++++++++++++--------
1 file changed, 13 insertions(+), 8 deletions(-)