Skip site navigation (1) Skip section navigation (2)

Lock levels for ALTER TABLE

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Lock levels for ALTER TABLE
Date: 2013-01-10 02:22:48
Message-ID: 20130110022248.GA15524@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


Responses

pgsql-hackers by date

Next:From: Noah MischDate: 2013-01-10 02:36:55
Subject: Re: Index build temp files
Previous:From: Tom LaneDate: 2013-01-10 01:56:35
Subject: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in "34.41. schemata")

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group