Postgres Pro
Downloads
Home   >   mailing lists

Re: Gaps in PK sequence numbers [RESOLVED] - Mailing list pgsql-general

From David G. Johnston
Subject Re: Gaps in PK sequence numbers [RESOLVED]
Date
Msg-id CAKFQuwYM7c3PLfp=ExueegJdT4GjXCx9iaaco-x1vri8qF0tyg@mail.gmail.com
Whole thread Raw
In response to Re: Gaps in PK sequence numbers [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
On Monday, June 10, 2024, Rich Shepard <rshepard@appl-ecosys.com> wrote:

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.


setval

The bigint argument can be computed from a query.

David J.

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Gaps in PK sequence numbers [RESOLVED]
Next
From: Laurenz Albe
Date:
Subject: Re: Does trigger only accept functions?