diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:49 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:49 +0000 |
| commit | 510f058932c91dd2c2a5e7f3f03782956aedef0e (patch) | |
| tree | d2f79e96e930510ade48ec97dee95df9cb7ca874 | |
| parent | 2df2c3dca2cbfe98ab24db281ec4d1892e5d47bc (diff) | |
| download | postgresql-510f058932c91dd2c2a5e7f3f03782956aedef0e.tar.gz postgresql-510f058932c91dd2c2a5e7f3f03782956aedef0e.zip | |
Document that only a table's owner may TRUNCATE it. Per Keith Worthington.
| -rw-r--r-- | doc/src/sgml/ref/truncate.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index 15887590352..7650832a2aa 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.15 2003/09/19 21:06:39 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.15.2.1 2005/02/22 19:06:49 tgl Exp $ PostgreSQL documentation --> @@ -54,6 +54,10 @@ TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name</replaceable> <title>Notes</title> <para> + Only the owner of a table may <command>TRUNCATE</> it. + </para> + + <para> <command>TRUNCATE</> cannot be used if there are foreign-key references to the table from other tables. Checking validity in such cases would require table scans, and the whole point is not to do one. |