Request a Demo
Home   >   mailing lists

Lock levels for ALTER TABLE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Lock levels for ALTER TABLE
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: Lock levels for ALTER TABLE
Re: Lock levels for ALTER TABLE
List pgsql-hackers
Tree view 
EnterpriseDB reports that our documentation states that ALTER TABLE
takes SHARE UPDATE EXCLUSIVE and ACCESS EXCLUSIVE lock modes.  However,
their testing shows only ACCESS EXCLUSIVE locks.  Is this accurate? 
Have we changed how ALTER TABLE locks but didn't update our docs?
--  Bruce Momjian  <[email protected]>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata")
Next
From: Noah Misch
Date:
Subject: Re: Index build temp files