|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_sequence.sgml,v 1.15 2002/07/12 18:43:13 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_sequence.sgml,v 1.16 2002/07/18 15:49:08 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -42,6 +42,23 @@ DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD |
42 | 42 | </para> |
43 | 43 | </listitem> |
44 | 44 | </varlistentry> |
| 45 | + <varlistentry> |
| 46 | + <term>CASCADE</term> |
| 47 | + <listitem> |
| 48 | + <para> |
| 49 | + Automatically drop objects that depend on the sequence. |
| 50 | + </para> |
| 51 | + </listitem> |
| 52 | + </varlistentry> |
| 53 | + <varlistentry> |
| 54 | + <term>RESTRICT</term> |
| 55 | + <listitem> |
| 56 | + <para> |
| 57 | + Refuse to drop the sequence if there are any dependent objects. |
| 58 | +This is the default. |
| 59 | + </para> |
| 60 | + </listitem> |
| 61 | + </varlistentry> |
45 | 62 | </variablelist> |
46 | 63 | </para> |
47 | 64 | </refsect2> |
@@ -76,23 +93,6 @@ ERROR: sequence "<replaceable class="parameter">name</replaceable>" does not exi |
76 | 93 | </para> |
77 | 94 | </listitem> |
78 | 95 | </varlistentry> |
79 | | - <varlistentry> |
80 | | - <term>CASCADE</term> |
81 | | - <listitem> |
82 | | - <para> |
83 | | - Automatically drop objects that depend on the sequence. |
84 | | - </para> |
85 | | - </listitem> |
86 | | - </varlistentry> |
87 | | - <varlistentry> |
88 | | - <term>RESTRICT</term> |
89 | | - <listitem> |
90 | | - <para> |
91 | | - Refuse to drop the sequence if there are any dependent objects. |
92 | | -This is the default. |
93 | | - </para> |
94 | | - </listitem> |
95 | | - </varlistentry> |
96 | 96 | </variablelist> |
97 | 97 |
|
98 | 98 | </para> |
|