On Wed, 2002-12-04 at 17:33, Dustin Sallings wrote: > What's wrong with this: > > dustin=# create sequence test_seq; > CREATE SEQUENCE > dustin=# select nextval('test_seq'); > nextval > --------- > 1 > (1 row) > > dustin=# select setval('test_seq', 9999); > setval > -------- > 9999 > (1 row) > > dustin=# select nextval('test_seq'); > nextval > --------- > 10000 > (1 row)
It's not the issue. The original question was how to change the upper limit of the sequence's range, not its current value. junk=# create sequence foo_seq maxvalue 3000; CREATE SEQUENCE junk=# select nextval('foo_seq'); nextval --------- 1 (1 row) junk=# select setval('foo_seq', 999999); ERROR: foo_seq.setval: value 999999 is out of bounds (1,3000) -- Oliver Elphick <[EMAIL PROTECTED]> LFIX Limited ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly