|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/lock.sgml,v 1.41 2004/03/11 01:47:35 ishii Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/lock.sgml,v 1.42 2004/03/12 00:52:23 neilc Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -33,13 +33,15 @@ where <replaceable class="PARAMETER">lockmode</replaceable> is one of: |
33 | 33 | <title>Description</title> |
34 | 34 |
|
35 | 35 | <para> |
36 | | - <command>LOCK TABLE</command> obtains a table-level lock, waiting if |
37 | | - necessary for any conflicting locks to be released. |
38 | | - If <literal>NOWAIT</literal> is given, <command>LOCK TABLE</command> |
39 | | - does not wait for acquiring lock, and throws an error instead. |
40 | | - Once obtained, the lock is held for the remainder of the current transaction. |
41 | | - (There is no <command>UNLOCK TABLE</command> command; locks are always |
42 | | - released at transaction end.) |
| 36 | + <command>LOCK TABLE</command> obtains a table-level lock, waiting |
| 37 | + if necessary for any conflicting locks to be released. If |
| 38 | + <literal>NOWAIT</literal> is specified, <command>LOCK |
| 39 | + TABLE</command> does not wait to acquire the desired lock: if it |
| 40 | + cannot be immediately acquired, the transaction is aborted and an |
| 41 | + error is emitted. Once obtained, the lock is held for the |
| 42 | + remainder of the current transaction. (There is no <command>UNLOCK |
| 43 | + TABLE</command> command; locks are always released at transaction |
| 44 | + end.) |
43 | 45 | </para> |
44 | 46 |
|
45 | 47 | <para> |
@@ -132,6 +134,18 @@ where <replaceable class="PARAMETER">lockmode</replaceable> is one of: |
132 | 134 | </para> |
133 | 135 | </listitem> |
134 | 136 | </varlistentry> |
| 137 | + |
| 138 | + <varlistentry> |
| 139 | + <term><literal>NOWAIT</literal></term> |
| 140 | + <listitem> |
| 141 | + <para> |
| 142 | + Specifies that <command>LOCK TABLE</command> should not wait for |
| 143 | + any conflicting locks to be released: if the specified lock |
| 144 | + cannot be immediately acquired without waiting, the transaction |
| 145 | + is aborted. |
| 146 | + </para> |
| 147 | + </listitem> |
| 148 | + </varlistentry> |
135 | 149 | </variablelist> |
136 | 150 | </refsect1> |
137 | 151 |
|
|
