Postgres Pro
Downloads
Home   >   mailing lists

DROP INDEX docs - explicit lock naming - Mailing list pgsql-hackers

From Greg Rychlewski
Subject DROP INDEX docs - explicit lock naming
Date
Msg-id CAKemG7VptD=7fNWckFMsMVZL_zzvgDO6v2yVmQ+ZiBfc_06kCQ@mail.gmail.com
Whole thread Raw
Responses Re: DROP INDEX docs - explicit lock naming  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view
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]
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Custom compression methods
Next
From: Tom Lane
Date:
Subject: Re: Issue with point_ops and NaN