pgsql: Adjust min/max values when changing sequence type

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(dot)paquier(at)gmail(dot)com>
Reviewed-by: Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)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(-)