The following bug has been logged online:
Bug reference: 5629
Logged by: Alexsander
Email address: [email protected]
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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs