2017-09-05 8:51 GMT+02:00 <eric.mord...@free.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.
