]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b75aa49) | 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)
commitaa4416dcd924a49e766baae9c73e884249d687d0
tree8a756cee099be55d1f3818e1c8aa11958541f257tree | snapshot
parentb75aa49bb8cbc96fc741791bc021a83a697a1307commit | 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