diff options
Diffstat (limited to 'doc/src/sgml/ref/alter_sequence.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_sequence.sgml | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index b515ae46016..3c982eee6f1 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.18 2007/10/03 16:48:43 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.19 2007/10/25 18:54:03 tgl Exp $ PostgreSQL documentation --> @@ -114,7 +114,10 @@ ALTER SEQUENCE <replaceable class="parameter">name</replaceable> SET SCHEMA <rep <para> The optional clause <literal>RESTART WITH <replaceable class="parameter">start</replaceable></literal> changes the - current value of the sequence. + current value of the sequence. This is equivalent to calling the + <function>setval</> function with <literal>is_called</literal> = + <literal>false</>: the specified value will be returned by the + <emphasis>next</> call of <function>nextval</>. </para> </listitem> </varlistentry> @@ -227,6 +230,12 @@ ALTER SEQUENCE <replaceable class="parameter">name</replaceable> SET SCHEMA <rep </para> <para> + <command>ALTER SEQUENCE</command> does not affect the <function>currval</> + status for the sequence. (Before <productname>PostgreSQL</productname> + 8.3, it sometimes did.) + </para> + + <para> Some variants of <command>ALTER TABLE</command> can be used with sequences as well; for example, to rename a sequence it is also possible to use <command>ALTER TABLE RENAME</command>. |