pgsql: Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KE - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KE
Date
Msg-id E1jMxDP-0000bp-94@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1d676ffd41be443d0c7a715f3e03841430ba4a2b

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


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Suppress unused-variable warning.
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: doc: add examples of creative use of unique expressionindexes