Re: 'alter sequence xxx start 200' do nothing

2017-09-05 8:51 GMT+02:00 <eric(dot)mordant(at)free(dot)fr>:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/functions-sequence.html
> Description:
>
> Hello,
>
> According to the doc, with a sequence public.xxx working well, i tried:
>
> Alter sequence public.xxx start 200;
>
> and also:
> Alter sequence public.xxx start with 200
>
> It has no effect, without error message, but setval(200) work fine
>
> Misunderstand the doc or is it a bug (PostgreSql 9.6 x86 on localhost) ?
>
>
They don't do the same thing. ALTER SEQUENCE ... START ... sets the start
value, while setval sets the current value.

--
Guillaume.