|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.30 2008/11/14 10:22:47 petere Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/truncate.sgml,v 1.31 2008/12/18 10:45:00 petere Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -102,6 +102,13 @@ TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name</replaceable> [, ... ] |
102 | 102 | to truncate it. |
103 | 103 | </para> |
104 | 104 |
|
| 105 | + <para> |
| 106 | + <command>TRUNCATE</> acquires an access exclusive lock on the |
| 107 | + tables in operates on, which blocks all other concurrent operations |
| 108 | + on the table. If concurrent access to a table is required, then |
| 109 | + the <command>DELETE</> command should be used instead. |
| 110 | + </para> |
| 111 | + |
105 | 112 | <para> |
106 | 113 | <command>TRUNCATE</> cannot be used on a table that has foreign-key |
107 | 114 | references from other tables, unless all such tables are also truncated |
|