pgsql-server/ oc/src/sgml/reference.sgml oc/sr ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)postgresql(dot)org 03/03/20 02:02:11

Modified files:
doc/src/sgml : reference.sgml
doc/src/sgml/ref: allfiles.sgml create_sequence.sgml
src/backend/commands: sequence.c
src/backend/nodes: copyfuncs.c equalfuncs.c
src/backend/parser: gram.y keywords.c
src/backend/tcop: postgres.c utility.c
src/include/commands: sequence.h
src/include/nodes: nodes.h parsenodes.h
src/test/regress: parallel_schedule serial_schedule
src/test/regress/expected: alter_table.out create_misc.out
src/test/regress/sql: alter_table.sql create_misc.sql
Added files:
doc/src/sgml/ref: alter_sequence.sgml
src/test/regress/expected: sequence.out
src/test/regress/sql: sequence.sql

Log message:
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(at)rbt(dot)ca>