Re: [BUGS] BUG #5629: ALTER SEQUENCE foo START execute a RESTART

Thu, 26 Aug 2010 14:23:28 -0700 

"Alexsander" <[email protected]> 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

-- 
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to