public inbox for [email protected]help / color / mirror / Atom feed
Correcting sequence in a table 3+ messages / 3 participants [nested] [flat]
* Correcting sequence in a table @ 2024-10-23 20:16 Erik Serrano <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Erik Serrano @ 2024-10-23 20:16 UTC (permalink / raw) To: Pgsql-admin <[email protected]> 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* ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Correcting sequence in a table @ 2024-10-23 20:28 [email protected] parent: Erik Serrano <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: [email protected] @ 2024-10-23 20:28 UTC (permalink / raw) To: [email protected] 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Correcting sequence in a table @ 2024-10-24 12:23 Muhammad Ikram <[email protected]> parent: Erik Serrano <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Muhammad Ikram @ 2024-10-24 12:23 UTC (permalink / raw) To: Erik Serrano <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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 <[email protected]> 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* > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-10-24 12:23 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-23 20:16 Correcting sequence in a table Erik Serrano <[email protected]> 2024-10-23 20:28 ` [email protected] 2024-10-24 12:23 ` Muhammad Ikram <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox