On 2017-05-18 10:11:48 -0400, Tom Lane wrote: > Christoph Berg <m...@debian.org> writes: > > *** 34,44 **** > > --- 34,47 ---- > > CREATE SEQUENCE sequence_test7 AS bigint; > > CREATE SEQUENCE sequence_test8 AS integer MAXVALUE 100000; > > CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1; > > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data > > type integer > > CREATE SEQUENCE sequence_test10 AS integer MINVALUE -100000 START 1; > > CREATE SEQUENCE sequence_test11 AS smallint; > > CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1; > > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data > > type smallint > > CREATE SEQUENCE sequence_test13 AS smallint MINVALUE -32768; > > CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1; > > + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data > > type smallint > > CREATE SEQUENCE sequence_testx AS text; > > ERROR: sequence type must be smallint, integer, or bigint > > CREATE SEQUENCE sequence_testx AS nosuchtype; > > Well, that's just wacko. Somehow sequence.c's init_params() must > be falling down on the job in selecting the right seqform->seqmin, > but I'm darned if I see anything that's either wrong or potentially > machine-dependent in that code. It almost looks like it must be > a compiler bug, though I hesitate to jump to that conclusion so > quickly. Peter, any ideas?
Weird. Christoph, IIRC you can help gaining access to a porter machine to reproduce this? - Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
