Horton

DROP INDEX docs - explicit lock naming

Greg Rychlewski <greg.rychlewski@gmail.com>

View thread View on postgr.es
From: Greg Rychlewski <greg.rychlewski@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-03-30T14:33:46Z
Lists: pgsql-hackers

Attachments

Hi,

While reading the documentation for DROP INDEX[1], I noticed the lock was
described colloquially as an "exclusive" lock, which made me pause for a
second because it's the same name as the EXCLUSIVE table lock.

The attached patch explicitly states that an ACCESS EXCLUSIVE lock is
acquired.

[1]
https://www.postgresql.org/docs/current/sql-dropindex.html

Commits

  1. doc: Clarify use of ACCESS EXCLUSIVE lock in various sections