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>
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/60a0b2ec8943451186dfa22907f88334d97cb2e0
Modified Files
--------------
doc/src/sgml/ref/alter_sequence.sgml | 13 ++++++----
src/backend/commands/sequence.c | 43 ++++++++++++++++++++++++++--------
src/test/regress/expected/sequence.out | 40 +++++++++++++++++++++++++++----
src/test/regress/sql/sequence.sql | 22 ++++++++++++++---
4 files changed, 96 insertions(+), 22 deletions(-)