Обсуждение: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error

Поиск
Список
Период
Сортировка

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

От
PG Doc comments form
Дата:
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.

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

От
"David G. Johnston"
Дата:
On Sun, Aug 20, 2023 at 8:56 AM PG Doc comments form <noreply@postgresql.org> wrote:
When the folloing SQL is executed:
ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
then an error is returned:

Yes, because if you take the RESTART branch in the syntax there is no word SET preceding RESTART.

Please fix the documentation or the functionality.

The documentation is already correct.

David J.