]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7b99e46) | patch
Doc: clarify locking requirements for ALTER TABLE ADD FOREIGN KEY.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Apr 2020 17:12:58 +0000 (13:12 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Apr 2020 17:12:58 +0000 (13:12 -0400)
commit2cab4ad81bcb44ccd6591ed1fb54495c7301b42d
treeb10f26b99b9ceb91ad08dcd003f0457ae78c8784tree | snapshot
parent7b99e46742fc93e0cd8d48b0eec55eca1a7b2790commit | diff
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
doc/src/sgml/ref/alter_table.sgml diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git