|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.80 2007/12/03 23:49:50 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.81 2008/01/13 17:58:54 tgl Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="ddl"> |
4 | 4 | <title>Data Definition</title> |
@@ -1034,12 +1034,14 @@ CREATE TABLE order_items ( |
1034 | 1034 | </para> |
1035 | 1035 |
|
1036 | 1036 | <para> |
1037 | | - Command |
1038 | | - identifiers are also 32-bit quantities. This creates a hard limit |
| 1037 | + Command identifiers are also 32-bit quantities. This creates a hard limit |
1039 | 1038 | of 2<superscript>32</> (4 billion) <acronym>SQL</acronym> commands |
1040 | 1039 | within a single transaction. In practice this limit is not a |
1041 | 1040 | problem — note that the limit is on number of |
1042 | 1041 | <acronym>SQL</acronym> commands, not number of rows processed. |
| 1042 | + Also, as of <productname>PostgreSQL</productname> 8.3, only commands |
| 1043 | + that actually modify the database contents will consume a command |
| 1044 | + identifier. |
1043 | 1045 | </para> |
1044 | 1046 | </sect1> |
1045 | 1047 |
|
|