|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.3 2001/09/03 12:57:50 petere Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.4 2001/11/18 21:14:20 tgl Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -84,7 +84,13 @@ TRUNCATE |
84 | 84 | <command>TRUNCATE</command> quickly removes all rows from a |
85 | 85 | table. It has the same effect as an unqualified |
86 | 86 | <command>DELETE</command> but since it does not actually scan the |
87 | | - table it is faster. This is most effective on large tables. |
| 87 | + table it is faster. This is most useful on large tables. |
| 88 | + </para> |
| 89 | + |
| 90 | + <para> |
| 91 | + <command>TRUNCATE</command> cannot be executed inside a transaction |
| 92 | + block (<command>BEGIN</>/<command>COMMIT</> pair), because there is |
| 93 | + no way to roll it back. |
88 | 94 | </para> |
89 | 95 | </refsect1> |
90 | 96 |
|
|