diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-01-12 08:54:27 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-01-12 08:54:27 +0000 |
| commit | ca8100f9eb7f02f410d1a45f2d5fee8373eace84 (patch) | |
| tree | a0c0a386c23b028fc3b704f9fc0ee1da5c19349c /doc/src | |
| parent | b7b8f0b6096d2ab6e4f67980d19e478cf6fab629 (diff) | |
Add ONLY support to LOCK and TRUNCATE. By default, these commands are now
recursive.
=> Note this incompatibility in the release notes.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/lock.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/truncate.sgml | 9 |
2 files changed, 11 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index f49d18618c3..567f3634511 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.51 2008/11/14 10:22:47 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/lock.sgml,v 1.52 2009/01/12 08:54:25 petere Exp $ PostgreSQL documentation --> @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ IN <replaceable class="PARAMETER">lockmode</replaceable> MODE ] [ NOWAIT ] +LOCK [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ IN <replaceable class="PARAMETER">lockmode</replaceable> MODE ] [ NOWAIT ] where <replaceable class="PARAMETER">lockmode</replaceable> is one of: @@ -109,7 +109,9 @@ where <replaceable class="PARAMETER">lockmode</replaceable> is one of: <listitem> <para> The name (optionally schema-qualified) of an existing table to - lock. + lock. If <literal>ONLY</> is specified, only that table is + locked. If <literal>ONLY</> is not specified, the table and all + its descendant tables (if any) are locked. </para> <para> diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index d765c1bd8c7..a512b9a52d2 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.31 2008/12/18 10:45:00 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.32 2009/01/12 08:54:25 petere Exp $ PostgreSQL documentation --> @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ... ] +TRUNCATE [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ... ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ] </synopsis> </refsynopsisdiv> @@ -47,7 +47,10 @@ TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ... ] <term><replaceable class="PARAMETER">name</replaceable></term> <listitem> <para> - The name (optionally schema-qualified) of a table to be truncated. + The name (optionally schema-qualified) of a table to be + truncated. If <literal>ONLY</> is specified, only that table is + truncated. If <literal>ONLY</> is not specified, the table and + all its descendant tables (if any) are truncated. </para> </listitem> </varlistentry> |