create or replace procedure test_setval()
language plpgsql
as $$
declare
begin
perform setval('test_seq', (select max(id) from test));
end;
$$