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') 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