From a0c12d5e905fdea19cf529af4f2d76e74412abc8 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sat, 23 Jun 2001 00:07:34 +0000
Subject: Add TEMPORARY sequences and have SERIAL on a temp table have a
temporary sequence.
---
doc/src/sgml/ref/create_sequence.sgml | 17 +++++++++++++++--
1 file changed, 15 insertions(+), 2 deletions(-)
(limited to 'doc/src/sgml/ref/create_sequence.sgml')
diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml
index 718037785c2..f6a2614f36d 100644
--- a/doc/src/sgml/ref/create_sequence.sgml
+++ b/doc/src/sgml/ref/create_sequence.sgml
@@ -1,5 +1,5 @@
@@ -23,7 +23,7 @@ Postgres documentation
1999-07-20
-CREATE SEQUENCE seqname [ INCREMENT increment ]
+CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT increment ]
[ MINVALUE minvalue ] [ MAXVALUE maxvalue ]
[ START start ] [ CACHE cache ] [ CYCLE ]
@@ -37,6 +37,19 @@ CREATE SEQUENCE seqname [ INCREMENT
+
+
+ TEMPORARY or TEMP
+
+
+ If specified, the sequence is created only for this session, and is
+ automatically dropped on session exit.
+ Existing permanent sequences with the same name are not visible
+ (in this session) while the temporary sequence exists.
+
+
+
+
seqname
--
cgit v1.2.3