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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexsander" <alexsander(dot)rosa(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART
Date: 2010-08-26 21:23:11
Message-ID: 29706.1282857791@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alexsander" <alexsander(dot)rosa(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexsander Rosa 2010-08-26 21:40:17 Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART
Previous Message Alvaro Herrera 2010-08-26 21:01:14 Re: BUG #5595: Documentation is not installs from VPATH build.