Re: Gaps in PK sequence numbers [RESOLVED]

> On Jun 10, 2024, at 18:10, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> Thanks, Christophe. Is there a way to reset the sequence to the maximum
> number +1? I don't recall seeing this in the postgres docs but will look
> again.

The sequence functions are documented here:

    https://www.postgresql.org/docs/current/functions-sequence.html

setval is the function you want.  You can use a SELECT so you don't have to copy values around:

    select setval('t_pk_seq', (select max(pk) from t));

That form of setval() sets the sequence so that the next value will be one more than the value you set it to, so you
don'thave to do max()+1 there.