SEQUENCE NAME syntax not documented for ALTER TABLE

Поиск
Список
Период
Сортировка
От Rene Saarsoo
Тема SEQUENCE NAME syntax not documented for ALTER TABLE
Дата
Msg-id CAMHv0CtmHUtXyoMcONRs6QVGHqG9utv=jZntU+5ur11A9eom=w@mail.gmail.com
обсуждение исходный текст
Ответы Re: SEQUENCE NAME syntax not documented for ALTER TABLE
Список pgsql-docs
Дерево обсуждения 
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

В списке pgsql-docs по дате отправления: