pgsql: Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KE
Started by Tom Laneover 6 years ago1 messagescomitters
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: /messages/by-id/834603375.3470346.1586482852542@mail.yahoo.com
Branch
------
REL_11_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/aa4416dcd924a49e766baae9c73e884249d687d0
Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 21 +++++++++++++--------
1 file changed, 13 insertions(+), 8 deletions(-)