postgres.git / summary / log / commit / refs

commit    7212c77d0cabcc468fec0b9cd7f2413b64b77050
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Thu Feb 03 20:14:27 2011 +0000
First released in: 9.1.0

    ALTER TABLE sometimes takes only ShareUpdateExclusiveLock.
    
    Along the way, be more consistent about the wording we use here.


doc/src/sgml/mvcc.sgml | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 152b7466b8b..579425dad64 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -656,7 +656,8 @@ SELECT SUM(value) FROM mytab WHERE class = 2; <para> Acquired by <command>VACUUM</command> (without <option>FULL</option>), - <command>ANALYZE</>, and <command>CREATE INDEX CONCURRENTLY</>. + <command>ANALYZE</>, <command>CREATE INDEX CONCURRENTLY</>, and + some forms of <command>ALTER TABLE</command>. </para> </listitem> </varlistentry> @@ -699,7 +700,7 @@ SELECT SUM(value) FROM mytab WHERE class = 2; <para> Acquired by <command>CREATE TRIGGER</command>, <command>CREATE RULE</command> (except for <literal>ON SELECT</> - rules) and in some cases <command>ALTER TABLE</command>. + rules) and some forms of <command>ALTER TABLE</command>. </para> </listitem> </varlistentry> @@ -747,7 +748,7 @@ SELECT SUM(value) FROM mytab WHERE class = 2; Acquired by the <command>DROP TABLE</command>, <command>TRUNCATE</command>, <command>REINDEX</command>, <command>CLUSTER</command>, and <command>VACUUM FULL</command> - commands, as well as most variants of <command>ALTER TABLE</>. + commands, and some forms of <command>ALTER TABLE</>. This is also the default lock mode for <command>LOCK TABLE</command> statements that do not specify a mode explicitly. </para> [parent: df63aac67834]