diff options
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/ref/lock.sgml | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 20530d75d71..b66f42e7ebc 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.26 2001/08/04 22:01:38 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.27 2001/08/10 14:30:14 momjian Exp $ Postgres documentation --> @@ -15,7 +15,7 @@ Postgres documentation LOCK </refname> <refpurpose> - Explicitly lock a table inside a transaction + Explicitly lock a table / tables inside a transaction </refpurpose> </refnamediv> <refsynopsisdiv> @@ -23,8 +23,8 @@ Postgres documentation <date>2001-07-09</date> </refsynopsisdivinfo> <synopsis> -LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> -LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> IN <replaceable class="PARAMETER">lockmode</replaceable> MODE +LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ...] +LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ...] IN <replaceable class="PARAMETER">lockmode</replaceable> MODE where <replaceable class="PARAMETER">lockmode</replaceable> is one of: @@ -373,6 +373,7 @@ ERROR <replaceable class="PARAMETER">name</replaceable>: Table does not exist. An example for this rule was given previously when discussing the use of SHARE ROW EXCLUSIVE mode rather than SHARE mode. </para> + </listitem> </itemizedlist> @@ -383,6 +384,12 @@ ERROR <replaceable class="PARAMETER">name</replaceable>: Table does not exist. </para> </note> + <para> + When locking multiple tables, the command LOCK a, b; is equivalent to LOCK + a; LOCK b;. The tables are locked one-by-one in the order specified in the + <command>LOCK</command> command. + </para> + <refsect2 id="R2-SQL-LOCK-3"> <refsect2info> <date>1999-06-08</date> @@ -406,6 +413,7 @@ ERROR <replaceable class="PARAMETER">name</replaceable>: Table does not exist. <para> <command>LOCK</command> works only inside transactions. </para> + </refsect2> </refsect1> |