]> granicus.if.org Git - postgresql/commit
Todo items:
authorBruce Momjian <bruce@momjian.us>
Thu, 20 Mar 2003 07:02:11 +0000 (07:02 +0000)
committerBruce Momjian <bruce@momjian.us>
Thu, 20 Mar 2003 07:02:11 +0000 (07:02 +0000)
commit5f65225fa37bd244ee5487448ac542b2b2f47296
tree6fa88eb46e3ff9c1fd9fbe2f1d47bbacba2ffbc7
parent46bce088c19d0e20152bc9c5e25ce105cff4fa07
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>
22 files changed:
doc/src/sgml/ref/allfiles.sgml
doc/src/sgml/ref/alter_sequence.sgml [new file with mode: 0644]
doc/src/sgml/ref/create_sequence.sgml
doc/src/sgml/reference.sgml
src/backend/commands/sequence.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/parser/keywords.c
src/backend/tcop/postgres.c
src/backend/tcop/utility.c
src/include/commands/sequence.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/test/regress/expected/alter_table.out
src/test/regress/expected/create_misc.out
src/test/regress/expected/sequence.out [new file with mode: 0644]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/alter_table.sql
src/test/regress/sql/create_misc.sql
src/test/regress/sql/sequence.sql [new file with mode: 0644]