The following bug has been logged online:

Bug reference:      5629
Logged by:          Alexsander
Email address:      alexsander.r...@gmail.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.

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

Reply via email to