diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:18 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-02-22 19:06:18 +0000 |
| commit | 26b9a2860f5a62811ab6a197e8dee5195e14cce7 (patch) | |
| tree | 71cd116440da0d76ff700993a547c35b280df473 | |
| parent | 5a9dd0dc4f84a0e847535086fbbf547084a8af1e (diff) | |
| download | postgresql-26b9a2860f5a62811ab6a197e8dee5195e14cce7.tar.gz postgresql-26b9a2860f5a62811ab6a197e8dee5195e14cce7.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 03ee825ad52..fe68c5b334a 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.18 2005/01/27 03:17:08 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.19 2005/02/22 19:06:18 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 on a table that has foreign-key references from other tables, unless all such tables are also truncated in the same command. Checking validity in such cases would require table |