Then the docs are misleading:
http://www.postgresql.org/docs/8.3/static/sql-altersequence.html
According the docs, 8.3 does NOT have a START clause -- only RESTART. I
think a START clause should raise an error at 8.3 servers; there's a chance
of someone run the command in several servers (like a pgdiff) and get
different behaviour for the same command.
2010/8/26 Tom Lane <t...@sss.pgh.pa.us>
> "Alexsander" <alexsander.r...@gmail.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
>
--
Atenciosamente,
Alexsander da Rosa
Linux User #113925
"Extremismo na defesa da liberdade não é defeito.
Moderação na busca por justiça não é virtude."
-- Barry Goldwater
