diff options
author | Bruce Momjian <bruce@momjian.us> | 2001-08-04 19:39:00 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2001-08-04 19:39:00 +0000 |
commit | 16365ac75bc0089f6b1a3db537a58042caa38ab4 (patch) | |
tree | 1904bec6046528c3419bd50859a1183aadc14f37 /doc/src | |
parent | 0bfc64b3875268c054b064d06165044caecfabf6 (diff) | |
download | postgresql-16365ac75bc0089f6b1a3db537a58042caa38ab4.tar.gz postgresql-16365ac75bc0089f6b1a3db537a58042caa38ab4.zip |
Add LOCK A,B,C functionality as LOCK A;LOCK B;LOCK C; as agreed.
Neil Padgett
Diffstat (limited to 'doc/src')
-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 d576890acb9..58e53371c94 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.24 2001/07/09 22:18:33 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.25 2001/08/04 19:38:59 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> |