diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/mvcc.sgml | 12 | ||||
-rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 3 |
2 files changed, 9 insertions, 6 deletions
diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index e43a3be6d4e..958adc32bd3 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -909,9 +909,9 @@ ERROR: could not serialize access due to read/write dependencies among transact </para> <para> - This lock mode is not automatically acquired by any - <productname>PostgreSQL</productname> command. - </para> + Acquired by <command>CREATE TRIGGER</command> and many forms of + <command>ALTER TABLE</command> (see <xref linkend="SQL-ALTERTABLE">). + </para>> </listitem> </varlistentry> @@ -958,9 +958,9 @@ ERROR: could not serialize access due to read/write dependencies among transact <command>TRUNCATE</command>, <command>REINDEX</command>, <command>CLUSTER</command>, and <command>VACUUM FULL</command> commands. Many forms of <command>ALTER TABLE</> also acquire - a lock at this level (see <xref linkend="SQL-ALTERTABLE">). - This is also the default lock mode for <command>LOCK TABLE</command> - statements that do not specify a mode explicitly. + a lock at this level. This is also the default lock mode for + <command>LOCK TABLE</command> statements that do not specify + a mode explicitly. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 19baf2961a4..6a82730a4b4 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -406,6 +406,9 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable> mode, and triggers configured as <literal>ENABLE ALWAYS</literal> will fire regardless of the current replication mode. </para> + <para> + This command acquires a <literal>SHARE ROW EXCLUSIVE</literal> lock. + </para> </listitem> </varlistentry> |