diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-06-23 00:07:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-06-23 00:07:34 +0000 |
| commit | a0c12d5e905fdea19cf529af4f2d76e74412abc8 (patch) | |
| tree | 24aa5d7e7f470d024c7677a8d81d231962eb3002 /doc/src | |
| parent | 280b5f4be61af1c1ca740ee99fdc397156a97c71 (diff) | |
| download | postgresql-a0c12d5e905fdea19cf529af4f2d76e74412abc8.tar.gz postgresql-a0c12d5e905fdea19cf529af4f2d76e74412abc8.zip | |
Add TEMPORARY sequences and have SERIAL on a temp table have a temporary
sequence.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_sequence.sgml | 17 |
1 files changed, 15 insertions, 2 deletions
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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.15 2000/12/08 20:06:58 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.16 2001/06/23 00:07:33 momjian Exp $ Postgres documentation --> @@ -23,7 +23,7 @@ Postgres documentation <date>1999-07-20</date> </refsynopsisdivinfo> <synopsis> -CREATE SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT <replaceable class="parameter">increment</replaceable> ] +CREATE [ TEMPORARY | TEMP ] SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT <replaceable class="parameter">increment</replaceable> ] [ MINVALUE <replaceable class="parameter">minvalue</replaceable> ] [ MAXVALUE <replaceable class="parameter">maxvalue</replaceable> ] [ START <replaceable class="parameter">start</replaceable> ] [ CACHE <replaceable class="parameter">cache</replaceable> ] [ CYCLE ] </synopsis> @@ -39,6 +39,19 @@ CREATE SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT <variablelist> <varlistentry> + <term>TEMPORARY or TEMP</term> + <listitem> + <para> + 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. + </para> + </listitem> + </varlistentry> + + <variablelist> + <varlistentry> <term><replaceable class="parameter">seqname</replaceable></term> <listitem> <para> |