Обсуждение: Alter sequence restart parameter type

Поиск
Список
Период
Сортировка

Alter sequence restart parameter type

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/sql-altersequence.html
Description:

Hi!
I have some question about alter sequence. I can see in your documentation
https://www.postgresql.org/docs/12/sql-altersequence.html  Synopsis:
ALTER SEQUENCE [ IF EXISTS ] name
    [ AS data_type ]
    [ INCREMENT [ BY ] increment ]
    [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE
]
    [ START [ WITH ] start ]
    [ RESTART [ [ WITH ] restart ] ]
    [ CACHE cache ] [ [ NO ] CYCLE ]
    [ OWNED BY { table_name.column_name | NONE } ]

I use postgresql 12.6. I want to restart my sequence something like that:
alter sequence quiz_seq restart with ((select max(id) from quiz)+1); 
but I can't do it.  Please, clarify. Can I use only plain numbers like
that?
alter sequence quiz_seq restart with 42;

Is it possible to clarify the type of the parameter RESTART in the
documentation?

Re: Alter sequence restart parameter type

От
"David G. Johnston"
Дата:
On Sunday, April 25, 2021, PG Doc comments form <noreply@postgresql.org> wrote:

I use postgresql 12.6. I want to restart my sequence something like that:
alter sequence quiz_seq restart with ((select max(id) from quiz)+1);
but I can't do it.  Please, clarify. Can I use only plain numbers like
that?
alter sequence quiz_seq restart with 42;

Yes
 

Is it possible to clarify the type of the parameter RESTART in the
documentation?

Not,desirable.  This command isn’t special with regard to the fact the utility commands don’t get to use embedded queries to supply values.  Though you can just write some pl/pgsql and build a dynamic command.

David J.