diff options
| author | Bruce Momjian | 2003-03-20 07:02:11 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2003-03-20 07:02:11 +0000 |
| commit | 5f65225fa37bd244ee5487448ac542b2b2f47296 (patch) | |
| tree | 6fa88eb46e3ff9c1fd9fbe2f1d47bbacba2ffbc7 /src/include/commands | |
| parent | 46bce088c19d0e20152bc9c5e25ce105cff4fa07 (diff) | |
Todo items:
Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
Also updated create sequence docs to mention NO MINVALUE, & NO MAXVALUE.
New Files:
doc/src/sgml/ref/alter_sequence.sgml
src/test/regress/expected/sequence.out
src/test/regress/sql/sequence.sql
ALTER SEQUENCE is NOT transactional. It behaves similarly to setval().
It matches the proposed SQL200N spec, as well as Oracle in most ways --
Oracle lacks RESTART WITH for some strange reason.
--
Rod Taylor <rbt@rbt.ca>
Diffstat (limited to 'src/include/commands')
| -rw-r--r-- | src/include/commands/sequence.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/commands/sequence.h b/src/include/commands/sequence.h index d4513de8c2..a0a18f0f33 100644 --- a/src/include/commands/sequence.h +++ b/src/include/commands/sequence.h @@ -6,7 +6,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: sequence.h,v 1.22 2003/03/20 05:18:15 momjian Exp $ + * $Id: sequence.h,v 1.23 2003/03/20 07:02:11 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -84,6 +84,7 @@ extern Datum setval(PG_FUNCTION_ARGS); extern Datum setval_and_iscalled(PG_FUNCTION_ARGS); extern void DefineSequence(CreateSeqStmt *stmt); +extern void AlterSequence(AlterSeqStmt *stmt); extern void seq_redo(XLogRecPtr lsn, XLogRecord *rptr); extern void seq_undo(XLogRecPtr lsn, XLogRecord *rptr); |