diff options
| author | Tatsuo Ishii <ishii@postgresql.org> | 2004-03-11 01:47:41 +0000 |
|---|---|---|
| committer | Tatsuo Ishii <ishii@postgresql.org> | 2004-03-11 01:47:41 +0000 |
| commit | 0b86ade1c2f3dcd2407e535baad1654e65252316 (patch) | |
| tree | f643be1064f229e2245c30467e2d12923ba0f677 /doc/src | |
| parent | 60a068b3897a27cbb1a13a6b050d05a0ca479055 (diff) | |
| download | postgresql-0b86ade1c2f3dcd2407e535baad1654e65252316.tar.gz postgresql-0b86ade1c2f3dcd2407e535baad1654e65252316.zip | |
Add NOWAIT option to LOCK command
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/lock.sgml | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index e78ee548fc5..a2c2a78a7aa 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/lock.sgml,v 1.40 2003/12/14 00:05:29 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/lock.sgml,v 1.41 2004/03/11 01:47:35 ishii Exp $ PostgreSQL documentation --> @@ -20,7 +20,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ IN <replaceable class="PARAMETER">lockmode</replaceable> MODE ] +LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ IN <replaceable class="PARAMETER">lockmode</replaceable> MODE ] [ NOWAIT ] where <replaceable class="PARAMETER">lockmode</replaceable> is one of: @@ -34,8 +34,10 @@ where <replaceable class="PARAMETER">lockmode</replaceable> is one of: <para> <command>LOCK TABLE</command> obtains a table-level lock, waiting if - necessary for any conflicting locks to be released. Once obtained, - the lock is held for the remainder of the current transaction. + necessary for any conflicting locks to be released. + If <literal>NOWAIT</literal> is given, <command>LOCK TABLE</command> + does not wait for acquiring lock, and throws an error instead. + Once obtained, the lock is held for the remainder of the current transaction. (There is no <command>UNLOCK TABLE</command> command; locks are always released at transaction end.) </para> |