diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-01-16 19:50:03 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-01-16 19:50:03 +0000 |
| commit | 92003189729afa1dd1c78feed387c559b053d61f (patch) | |
| tree | 24c4d59d4956953cd23d2bfef53bf68371612bbb | |
| parent | b06e6f1a9a8cdae98654eb984cd3a190e2b08a3d (diff) | |
| download | postgresql-92003189729afa1dd1c78feed387c559b053d61f.tar.gz postgresql-92003189729afa1dd1c78feed387c559b053d61f.zip | |
Add documentaiotn mention that constraint names can be sentences that
can convey information to clients on constraint violation.
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index adfcd13ff0d..2c5e14caf24 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.96 2005/11/01 21:09:50 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.97 2006/01/16 19:50:03 momjian Exp $ PostgreSQL documentation --> @@ -293,7 +293,10 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: <term><literal>CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable></literal></term> <listitem> <para> - An optional name for a column or table constraint. If not specified, + An optional name for a column or table constraint. If the + constraint is violated, the constraint name is present in error messages, + so constraint names like "col must be positive" can be used to communicate + helpful constraint information to client applications. If not specified, the system generates a name. </para> </listitem> |