Postgres Pro
Downloads
Home   >   mailing lists

Thread: Correcting sequence in a table

Correcting sequence in a table

From
Erik Serrano
Date:
Correcting sequence in a table

Dear Sirs,

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.


Thank you very much in advance



Erik R. Serrano Saavedra

Re: Correcting sequence in a table

From
shammat@gmx.net
Date:
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.

Re: Correcting sequence in a table

From
Muhammad Ikram
Date:
Hi

Could you please elaborate your query ? Not able to understand your requirement

Regards,
Ikram


On Thu, Oct 24, 2024 at 1:16 AM Erik Serrano <eserranos@gmail.com> wrote:
Correcting sequence in a table

Dear Sirs,

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.


Thank you very much in advance



Erik R. Serrano Saavedra