diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:35 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:35 +0000 |
| commit | 777745435c069859651a8ed4b4c938b23d15392f (patch) | |
| tree | 1afbb61f4bce8665a48e31c57ff7a1a037cc2b0a | |
| parent | 7f6754bdb496eb23c0bce4fbe066e859c0f74e2e (diff) | |
| download | postgresql-777745435c069859651a8ed4b4c938b23d15392f.tar.gz postgresql-777745435c069859651a8ed4b4c938b23d15392f.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 8bd220f77a7..babd4033d4c 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.17 2004/03/23 13:21:41 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.17.4.1 2005/02/22 19:06:35 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. |