Re: SEQUENCE NAME syntax not documented for ALTER TABLE

Rene Saarsoo writes: > The documentation for ALTER TABLE [1] doesn't make it clear that the > following is allowed: > ... > It only references the sequence options allowed in CREATE SEQUENCE or ALTER > SEQUENCE, unlike the CREATE TABLE [2] documentation, which does > specifically state [3]: Huh?

SEQUENCE NAME syntax not documented for ALTER TABLE

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 TABL