Postgresql - Using subqueries with alter sequence expressions
alter, postgresql, sequence, sql, subquery
Solution
I don't believe you can do it like that but you should be able to use the setval function direction which is what the alter does.
select setval('sequenceX', (select max(table_id)+1 from table), false)
The false will make it return the next sequence number as exactly what is given.
Problem
Is it possible to use subqueries within alter expressions in PostgreSQL? I want to alter a sequence value based on a primary key column value. I tried using the following expression, but it wouldn't execute. ``` alter sequence public.sequenceX restart with (select max(table_id)+1 from table) ```