From d4019b7cd33e7d820013c8a58917e31cdcca57ed Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 9 Sep 2003 18:28:53 +0000 Subject: Remove a bunch of content-free Diagnostics sections, as per previous discussion. (Still have some work to do editing the remainder.) --- doc/src/sgml/ref/alter_sequence.sgml | 138 +++++++++-------------------------- 1 file changed, 35 insertions(+), 103 deletions(-) (limited to 'doc/src/sgml/ref/alter_sequence.sgml') diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index f12e9ad85a..f4b114da4b 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -1,5 +1,5 @@ @@ -23,24 +23,27 @@ PostgreSQL documentation - - 1999-07-20 - ALTER SEQUENCE seqname [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] - - - - 1998-09-11 - - - Inputs - - + + + Description + + + ALTER SEQUENCE changes the parameters of an existing + sequence generator. Any parameter not specifically set in the + ALTER SEQUENCE command retains its prior setting. + + + + + Parameters + + seqname @@ -100,8 +103,8 @@ ALTER SEQUENCE seqname [ INCREMENT The optional enables the sequence to re-begin anywhere. + start + clause changes the current value of the sequence. @@ -151,78 +154,11 @@ ALTER SEQUENCE seqname [ INCREMENT - - - - - 1998-09-11 - - - Outputs - - - - - - -ALTER SEQUENCE - - - - Message returned if the command is successful. - - - - - -ERROR: AlterSequence: MINVALUE (start) can't be >= MAXVALUE (max) - - - - If the specified starting value is out of range. - - - - - -ERROR: AlterSequence: START value (start) can't be < MINVALUE (min) - - - - If the specified starting value is out of range. - - - - - -ERROR: AlterSequence: MINVALUE (min) can't be >= MAXVALUE (max) - - - - If the minimum and maximum values are inconsistent. - - - - - - - + - - - Description - - - - See for limitations, and uses - of sequences. - - + + Examples - - - Usage - Restart a sequence called serial, at 105: @@ -231,35 +167,31 @@ ALTER SEQUENCE serial RESTART WITH 105; - - - Notes - + + Notes + - To avoid blocking of concurrent transactions that obtain numbers from the same - sequence, a nextval operation is never rolled back; that is, once a value has - been fetched it is considered used, even if the transaction that did the nextval - later aborts. This means that aborted transactions may leave unused "holes" in - the sequence of assigned values. setval operations are never rolled back, either. + To avoid blocking of concurrent transactions that obtain numbers from the + same sequence, ALTER SEQUENCE is never rolled back; + the changes take effect immediately and are not reversible. + - ALTER SEQUENCE will not immediately affect backends, other than the - current one, which have cached sequence values. They must use up all cached values - prior to noticing the changed sequence parameters. The current backend will be - immediatly affected. + ALTER SEQUENCE will not immediately affect + nextval results in backends, + other than the current one, that have preallocated (cached) sequence + values. They will use up all cached values prior to noticing the changed + sequence parameters. The current backend will be affected immediately. - + Compatibility - - - 2003-03-02 - + SQL99 -- cgit v1.2.1