diff options
| author | Marc G. Fournier | 1998-08-25 21:25:46 +0000 |
|---|---|---|
| committer | Marc G. Fournier | 1998-08-25 21:25:46 +0000 |
| commit | 8e9d69d6ac76001458f0c190a35990b23abf81de (patch) | |
| tree | f1b2ec4d5991f2963169b8964efcadc21d41bfd0 /src/include | |
| parent | 88b17d9c56bfd0b6d35b824e9edbce29ae241c33 (diff) | |
From: Massimo Dal Zotto <dz@cs.unitn.it>
> sequence.patch
>
> adds the missing setval command to sequences. Owner of sequences
> can now set the last value to any value between min and max
> without recreating the sequence. This is useful after loading
> data from external files.
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/catalog/pg_proc.h | 4 | ||||
| -rw-r--r-- | src/include/commands/sequence.h | 1 |
2 files changed, 4 insertions, 1 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 902b057f17..88f304ea1a 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -6,7 +6,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.67 1998/08/24 01:38:08 momjian Exp $ + * $Id: pg_proc.h,v 1.68 1998/08/25 21:25:44 scrappy Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -2029,6 +2029,8 @@ DATA(insert OID = 1317 ( nextval PGUID 11 f t f 1 f 23 "25" 100 0 0 100 fo DESCR("sequence next value"); DATA(insert OID = 1319 ( currval PGUID 11 f t f 1 f 23 "25" 100 0 0 100 foo bar )); DESCR("sequence current value"); +DATA(insert OID = 1618 ( setval PGUID 11 f t f 2 f 23 "25 23" 100 0 0 100 foo bar )); +DESCR("sequence set value"); /* for multi-byte support */ DATA(insert OID = 1039 ( getdatabaseencoding PGUID 11 f t f 0 f 19 "0" 100 0 0 100 foo bar )); diff --git a/src/include/commands/sequence.h b/src/include/commands/sequence.h index 2ffa42639b..f2186cccda 100644 --- a/src/include/commands/sequence.h +++ b/src/include/commands/sequence.h @@ -30,6 +30,7 @@ extern void DefineSequence(CreateSeqStmt *stmt); extern int4 nextval(struct varlena * seqname); extern int4 currval(struct varlena * seqname); +extern int4 setval (struct varlena * seqname, int4 next); extern void CloseSequences(void); #endif /* SEQUENCE_H */ |