diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-20 07:02:11 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-20 07:02:11 +0000 |
| commit | 5f65225fa37bd244ee5487448ac542b2b2f47296 (patch) | |
| tree | 6fa88eb46e3ff9c1fd9fbe2f1d47bbacba2ffbc7 /doc/src/sgml/reference.sgml | |
| 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 'doc/src/sgml/reference.sgml')
| -rw-r--r-- | doc/src/sgml/reference.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml index 9f5cdf8b912..3486ca41823 100644 --- a/doc/src/sgml/reference.sgml +++ b/doc/src/sgml/reference.sgml @@ -1,5 +1,5 @@ <!-- reference.sgml -$Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.41 2002/12/06 05:00:10 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.42 2003/03/20 07:02:07 momjian Exp $ PostgreSQL Reference Manual --> @@ -49,6 +49,7 @@ PostgreSQL Reference Manual &alterDatabase; &alterDomain; &alterGroup; + &alterSequence; &alterTable; &alterTrigger; &alterUser; |