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.paqu...@gmail.com>
Reviewed-by: Vitaly Burovoy <vitaly.buro...@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(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

Reply via email to