aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2011-02-03 15:14:27 -0500
committerRobert Haas <rhaas@postgresql.org>2011-02-03 15:14:27 -0500
commit7212c77d0cabcc468fec0b9cd7f2413b64b77050 (patch)
treea3abfb4ed163aabeb831b28878ab030f00688567 /doc/src
parentdf63aac678343cec522bc58588b70ab1374a6c93 (diff)
downloadpostgresql-7212c77d0cabcc468fec0b9cd7f2413b64b77050.tar.gz
postgresql-7212c77d0cabcc468fec0b9cd7f2413b64b77050.zip
ALTER TABLE sometimes takes only ShareUpdateExclusiveLock.
Along the way, be more consistent about the wording we use here.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/mvcc.sgml7
1 files 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>