Re: Gaps in PK sequence numbers [RESOLVED]

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Mon, 10 Jun 2024, Christophe Pettus wrote:

> 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't have to do max()+1 there.

Thanks again, Christophe.

Regards,

Rich