From d2f608251e621dbe4aff363154b3a27123cc3814 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 28 Nov 2001 15:33:48 +0000 Subject: [PATCH] Point out the dependency on having int8 arithmetic available. --- doc/src/sgml/ref/create_sequence.sgml | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 334d45dd8b..f2e343660d 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -1,5 +1,5 @@ @@ -287,9 +287,20 @@ SELECT * FROM seqname; Notes + Use DROP SEQUENCE to remove a sequence. + + + Sequences are based on bigint arithmetic, so the range cannot + exceed the range of an eight-byte integer + (-9223372036854775808 to 9223372036854775807). On some older platforms, + there may be no compiler support for eight-byte integers, in which case + sequences use regular integer arithmetic (range + -2147483648 to +2147483647). + + When cache is greater than one, each backend uses its own cache to store preallocated numbers. -- 2.11.0