The following bug has been logged online:
Bug reference: 5629
Logged by: Alexsander
Email address: alexsander(dot)rosa(at)gmail(dot)com
PostgreSQL version: 8.3.11
Operating system: Linux
Description: ALTER SEQUENCE foo START execute a RESTART
Details:
Steps to reproduce:
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.