Adjust min/max values when changing sequence type
authorPeter Eisentraut <peter_e@gmx.net>
Tue, 4 Apr 2017 16:36:15 +0000 (12:36 -0400)
committerPeter Eisentraut <peter_e@gmx.net>
Tue, 4 Apr 2017 16:49:39 +0000 (12:49 -0400)
commit60a0b2ec8943451186dfa22907f88334d97cb2e0
tree4be14644f7a4ce42f4300ef7b5cd134d3f4251d2
parenta9a7949134189c29a9b38ac7394c53849684fe4d
Adjust min/max values when changing sequence type

When changing the type of a sequence, adjust the min/max values of the
sequence if it looks like the previous values were the default values.
Previously, it would leave the old values in place, requiring manual
adjustments even in the usual/default cases.

Reviewed-by: Michael Paquier <michael.paquier@gmail.com>
Reviewed-by: Vitaly Burovoy <vitaly.burovoy@gmail.com>
doc/src/sgml/ref/alter_sequence.sgml
src/backend/commands/sequence.c
src/test/regress/expected/sequence.out
src/test/regress/sql/sequence.sql