Re: [DOCS] 'alter sequence xxx start 200' do nothing

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [DOCS] 'alter sequence xxx start 200' do nothing
Дата
Msg-id CAKFQuwZ0NAGEuxs-22ykewV5ju6U7eP09wY+LPtvPq7hGfsNJw@mail.gmail.com
обсуждение исходный текст
Ответ на [DOCS] 'alter sequence xxx start 200' do nothing  (eric.mordant@free.fr)
Список pgsql-docs
Дерево обсуждения
On Mon, Sep 4, 2017 at 11:51 PM, <eric.mordant@free.fr> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/functions-sequence.html

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) ?
​​

​From the  SQL Commands "ALTER SEQUENCE" chapter:

"The optional clause START WITH start changes the recorded start value of the sequence. This has no effect on the current sequence value; it simply sets the value that future ALTER SEQUENCE RESTART commands will use."  (emphasis mine)

https://www.postgresql.org/docs/9.5/static/sql-altersequence.html

David J.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: [DOCS] 'alter sequence xxx start 200' do nothing
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [DOCS] pg_inherits documentation clarification