|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.50 2001/12/08 03:24:35 thomas Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.51 2002/01/03 06:26:22 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -437,6 +437,13 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: |
437 | 437 | </varlistentry> |
438 | 438 | </variablelist> |
439 | 439 | </para> |
| 440 | + <para> |
| 441 | + If primary key column is updated frequently, it may be wise to |
| 442 | + add an index to the <literal>REFERENCES</literal> column so that |
| 443 | + <literal>NO ACTION</literal> and <literal>CASCADE</literal> |
| 444 | + actions associated with the <literal>REFERENCES</literal> |
| 445 | + column can be more efficiently performed. |
| 446 | + </para> |
440 | 447 |
|
441 | 448 | </listitem> |
442 | 449 | </varlistentry> |
@@ -472,6 +479,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: |
472 | 479 | </listitem> |
473 | 480 | </varlistentry> |
474 | 481 | </variablelist> |
| 482 | + |
| 483 | + |
475 | 484 | </refsect1> |
476 | 485 |
|
477 | 486 |
|
|