From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: kees.vivition@gmail.com
Subject: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
Date: Fri, 18 Aug 2023 10:50:24 +0000
Message-ID: <169235582431.648.3591710862838900614@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, kees.vivition@gmail.com
Subject: Re: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
In-Reply-To: <169235582431.648.3591710862838900614@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox