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.