ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
Дата
Msg-id 169235582431.648.3591710862838900614@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/sql-altertable.html
Description:

Hi,

When the folloing SQL is executed: 
ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
then an error is returned:
> ERROR:  sequence option "restart" not supported here
According to the documention for Postgres 15 on ALTER TABLE, the provided
command seems to be correct. Omitting 'WITH' did not help.
A similar ALTER SEQUENCE table_id_seq RESTART WITH nnn works fine.
The involved Postgres version is: PostgreSQL 15.3, compiled by Visual C++
build 1914, 64-bit

I also found a very similar error in an old mail:
https://www.postgresql.org/message-id/ed41b243-63b2-f287-e7b0-8b2ac7266d66%402ndquadrant.com

Please fix the documentation or the functionality.

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: In docs there is no "Installation from Binaries" section
Следующее
От: Erwin Brandstetter
Дата:
Сообщение: ROWS vs RANGE in release notes for pg 16