Re: Correcting sequence in a table

From: shammat(at)gmx(dot)net
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Correcting sequence in a table
Date: 2024-10-23 20:28:24
Message-ID: 00e28730-c505-480f-8133-211dee9c7134@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Usman Khan 2024-10-24 03:17:24 Re: Postgres capacity planning.
Previous Message Erik Serrano 2024-10-23 20:16:04 Correcting sequence in a table