Home > mailing lists

SEQUENCE NAME syntax not documented for ALTER TABLE - Mailing list pgsql-docs

From	Rene Saarsoo
Subject	SEQUENCE NAME syntax not documented for ALTER TABLE
Date	March 23 12:50:10
Msg-id	CAMHv0CtmHUtXyoMcONRs6QVGHqG9utv=jZntU+5ur11A9eom=w@mail.gmail.com Whole thread Raw
Responses	Re: SEQUENCE NAME syntax not documented for ALTER TABLE
List	pgsql-docs

Tree view

The documentation for ALTER TABLE [1] doesn't make it clear that the following is allowed:

ALTER TABLE tbl
ALTER COLUMN id
ADD GENERATED BY DEFAULT AS IDENTITY (  SEQUENCE NAME my_name
);

It only references the sequence options allowed in CREATE SEQUENCE or ALTER SEQUENCE, unlike the CREATE TABLE [2] documentation, which does specifically state [3]:

> The available options include those shown for CREATE SEQUENCE,

> plus SEQUENCE NAME name, LOGGED, and UNLOGGED

With best,

Rene Saarsoo

[1]: https://www.postgresql.org/docs/current/sql-altertable.html

[2]: https://www.postgresql.org/docs/current/sql-createtable.html

[3]: https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-PARMS-GENERATED-IDENTITY

pgsql-docs by date:

From: "David G. Johnston"
Date: 21 March, 05:04:18
Subject: Re: Ambiguity in IS JSON description and logic

From: Tom Lane
Date: 23 March, 18:31:37
Subject: Re: SEQUENCE NAME syntax not documented for ALTER TABLE

SEQUENCE NAME syntax not documented for ALTER TABLE - Mailing list pgsql-docs

Previous

Next