Re: Correcting sequence in a table - Mailing list pgsql-admin

From shammat@gmx.net
Subject Re: Correcting sequence in a table
Date
Msg-id 00e28730-c505-480f-8133-211dee9c7134@gmx.net
Whole thread Raw
In response to Correcting sequence in a table  (Erik Serrano <eserranos@gmail.com>)
List pgsql-admin
Am 23.10.24 um 22:16 schrieb Erik Serrano:
> Along with greetings, I would like you to help me or guide me in how
> to correct the sequence of a table from which old information was
> deleted. The table also has dependencies.

What exactly do you mean with "correct the sequence"?

After you deleted rows from a table, there is nothing to do with regards
to the sequence used by that table.

There is absolutely no point in re-using "unused" values. "Gaps" in the
number are completely irrelevant.





pgsql-admin by date:

Previous
From: Erik Serrano
Date:
Subject: Correcting sequence in a table
Next
From: Muhammad Usman Khan
Date:
Subject: Re: Postgres capacity planning.