"Peter Alberer" <peter(dot)alberer(at)wu-wien(dot)ac(dot)at> writes:
> The command
> CREATE SEQUENCE assignment_task_elements_seq2
> INCREMENT BY 1
> MAXVALUE 9223372036854775807
> NO MINVALUE
> CACHE 1;
> Causes the following error: MINVALUE (1) must be less than MAXVALUE (-1)
Not for me. What *exactly* is the platform you are working on; what
compiler did you build Postgres with; and with what options? It looks
like something is narrowing the 64-bit maxvalue to 32 bits, but it's far
from clear why.
Have you run the PG regression tests on this build, and do they pass
(particularly the int8 test)?
regards, tom lane