diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-08-04 22:01:39 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-08-04 22:01:39 +0000 |
| commit | d1c9633060fbb6c062e642e1b7e0d08bbd3d31ce (patch) | |
| tree | aa99ea3e580272a90172ee54c2834eceec32de39 /doc/src | |
| parent | eb610fb8f1c2efe4f4dd454563598d4841a1b732 (diff) | |
| download | postgresql-d1c9633060fbb6c062e642e1b7e0d08bbd3d31ce.tar.gz postgresql-d1c9633060fbb6c062e642e1b7e0d08bbd3d31ce.zip | |
Back out LOCK A,B,C patch at Tom's suggestion.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/lock.sgml | 16 |
1 files changed, 4 insertions, 12 deletions
diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 58e53371c94..20530d75d71 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.25 2001/08/04 19:38:59 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.26 2001/08/04 22:01:38 momjian Exp $ Postgres documentation --> @@ -15,7 +15,7 @@ Postgres documentation LOCK </refname> <refpurpose> - Explicitly lock a table / tables inside a transaction + Explicitly lock a table 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,7 +373,6 @@ 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> @@ -384,12 +383,6 @@ 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> @@ -413,7 +406,6 @@ ERROR <replaceable class="PARAMETER">name</replaceable>: Table does not exist. <para> <command>LOCK</command> works only inside transactions. </para> - </refsect2> </refsect1> |