Fix default minimum value for descending sequences
authorPeter Eisentraut <peter_e@gmx.net>
Mon, 23 Jan 2017 19:00:58 +0000 (14:00 -0500)
committerPeter Eisentraut <peter_e@gmx.net>
Mon, 23 Jan 2017 19:00:58 +0000 (14:00 -0500)
commit0bc1207aeb3de951bf95a9e9899b1256216d65f5
treed6b29dbd49dec2ec22b65f0324924843c6a9bc7d
parent46d482814cd4a9c474540a9c4f040ce1cd514f46
Fix default minimum value for descending sequences

For some reason that is lost in history, a descending sequence would
default its minimum value to -2^63+1 (-PG_INT64_MAX) instead of
-2^63 (PG_INT64_MIN), even though explicitly specifying a minimum value
of -2^63 would work.  Fix this inconsistency by using the full range by
default.

Reported-by: Daniel Verite <daniel@manitou-mail.org>
Reviewed-by: Michael Paquier <michael.paquier@gmail.com>
doc/src/sgml/ref/create_sequence.sgml
src/backend/commands/sequence.c
src/bin/pg_dump/pg_dump.c
src/include/pg_config_manual.h