| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | kees(dot)vivition(at)gmail(dot)com |
| Subject: | ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error |
| Date: | 2023-08-18 10:50:24 |
| Message-ID: | 169235582431.648.3591710862838900614@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erwin Brandstetter | 2023-08-18 23:41:58 | ROWS vs RANGE in release notes for pg 16 |
| Previous Message | PG Doc comments form | 2023-08-18 10:31:58 | In docs there is no "Installation from Binaries" section |