|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.101 2006/06/27 03:43:19 momjian Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.102 2006/06/28 22:01:52 neilc Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -249,19 +249,19 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: |
249 | 249 | <para> |
250 | 250 | Default expressions for the copied column definitions will only be |
251 | 251 | copied if <literal>INCLUDING DEFAULTS</literal> is specified. The |
252 | | - default behavior is to exclude default expressions, resulting in |
253 | | -all columnsof the new table having null defaults. |
| 252 | + default behavior is to exclude default expressions, resulting in the |
| 253 | +copied columnsin the new table having null defaults. |
254 | 254 | </para> |
255 | 255 | <para> |
256 | | -Likewise constraintsfor the copiedcolumn definitions will only be |
257 | | -copied if<literal>INCLUDING CONSTRAINTS</literal>is specified. Note |
258 | | -that currently even when<literal>INCLUDING CONSTRAINTS</literal> is specified |
259 | | -only CHECK constraints are copied. Also, no distinction is made between |
260 | | - column constraints and table constraints-- when constraints are |
261 | | - requested all check constraints are copied. |
| 256 | +Not-null constraintsare always copiedto the new table. |
| 257 | + <literal>CHECK</literal>constraints will only be copied if |
| 258 | + <literal>INCLUDING CONSTRAINTS</literal> is specified; other types of |
| 259 | +constraints will never be copied. Also, no distinction is made between |
| 260 | + column constraints and table constraints— when constraints are |
| 261 | + requested, all check constraints are copied. |
262 | 262 | </para> |
263 | 263 | <para> |
264 | | - Note also that unlike <literal>INHERITS<literal> copied columns and |
| 264 | + Note also that unlike <literal>INHERITS</literal>, copied columns and |
265 | 265 | constraints are not merged with similarly named columns and constraints. |
266 | 266 | If the same name is specified explicitly or in another |
267 | 267 | <literal>LIKE</literal> clause an error is signalled. |
|
