diff options
author | Tom Lane | 2008-01-13 17:58:54 +0000 |
---|---|---|
committer | Tom Lane | 2008-01-13 17:58:54 +0000 |
commit | 05a381add9830f88c022a64f93ef6dd693ae2677 (patch) | |
tree | 9d071ca90f146235be651674759991f8f3ffa8a1 | |
parent | 149db6b6b78101717e61a4325c52abe7e45d3137 (diff) |
Add note pointing out that read-only commands no longer consume
command IDs.
-rw-r--r-- | doc/src/sgml/ddl.sgml | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index de06bbe359e..98233866300 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.80 2007/12/03 23:49:50 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.81 2008/01/13 17:58:54 tgl Exp $ --> <chapter id="ddl"> <title>Data Definition</title> @@ -1034,12 +1034,14 @@ CREATE TABLE order_items ( </para> <para> - Command - identifiers are also 32-bit quantities. This creates a hard limit + Command identifiers are also 32-bit quantities. This creates a hard limit of 2<superscript>32</> (4 billion) <acronym>SQL</acronym> commands within a single transaction. In practice this limit is not a problem — note that the limit is on number of <acronym>SQL</acronym> commands, not number of rows processed. + Also, as of <productname>PostgreSQL</productname> 8.3, only commands + that actually modify the database contents will consume a command + identifier. </para> </sect1> |