Adjust min/max values when changing sequence type
Peter Eisentraut <peter_e@gmx.net>
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>
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_sequence.sgml | modified | +9 −4 |
| src/backend/commands/sequence.c | modified | +33 −10 |
| src/test/regress/expected/sequence.out | modified | +35 −5 |
| src/test/regress/sql/sequence.sql | modified | +19 −3 |