Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART - Mailing list pgsql-bugs

"Alexsander" <alexsander.rosa@gmail.com> writes:
> CREATE SEQUENCE foo;
> SELECT setval('foo',12345);
> ALTER SEQUENCE foo START WITH 10; -- can't change value
> SELECT nextval('foo'); -- it's 10 instead of 12346

> Apparently START is executing a RESTART.

Yup.  That's what it's defined to do, pre-8.4.

            regards, tom lane