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

From Alexsander
Subject BUG #5629: ALTER SEQUENCE foo START execute a RESTART
Date
Msg-id 201008262052.o7QKqf3l026801@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART
List pgsql-bugs
The following bug has been logged online:

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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #5595: Documentation is not installs from VPATH build.
Next
From: Tom Lane
Date:
Subject: Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART