Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3hy2-00EDjf-Q4 for pgsql-admin@arkaria.postgresql.org; Wed, 23 Oct 2024 20:28:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t3hy1-00CwvB-5E for pgsql-admin@arkaria.postgresql.org; Wed, 23 Oct 2024 20:28:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3hy0-00Cwv3-Mr for pgsql-admin@lists.postgresql.org; Wed, 23 Oct 2024 20:28:29 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3hxy-002cVi-RM for pgsql-admin@lists.postgresql.org; Wed, 23 Oct 2024 20:28:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1729715305; x=1730320105; i=shammat@gmx.net; bh=O+83SWyZP+ZYl93WsZtRf2913INuf2udHh5Nl1rYf9I=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=NdYk+XyDumwMedzQTFYLLheO5lHLL11GvL9jzNWJOBqds0f7Q/f1RaIvpDEKfwAA b6+2BiRn6MZF8S/8qLVaJz2wboVpaCGpMpPWfo9T2/vD5Wfjc4+fN2PxNapZqgL1C PIU6GWMDMCccZION2XBMg1YF8ym/x852rkMdKZlmsNVWhPVLNJCxeHT/LwtMzGY9W NZmbYdl8j2HSHrLKfqoB+v0grR3zuRwhbCIKnRN9F3J13N8ELGQcR/MSnr/2sl1Io vMGGhaelnFo8Z3RSnh//RMNBGwupVHK1DEKMYvItFIy33LuRrE5KG5VVb6Byp5IPX MeRJJ1jsoDZgA3VOnA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.31] ([88.217.180.228]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MFKKX-1t5dtw0npR-007Ar1 for ; Wed, 23 Oct 2024 22:28:25 +0200 Message-ID: <00e28730-c505-480f-8133-211dee9c7134@gmx.net> Date: Wed, 23 Oct 2024 22:28:24 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Correcting sequence in a table To: pgsql-admin@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:cq94nqDkF+Nam6caRymmOQni00wamBs38rgpvS8ZZAUR5NP6hhs LLD8oVihNB4blIxUdJNTvc8kCC0rh6rO3ml194PUcdQ52sxcuOm2gIaDXW51juHO0y90ELD Gja2PacoQBko1ZIBivBzLB/WiCTYv4tHQvxD0z6hKgdw68sumkHZbYX/61IsJssIMaoHMDt EiCZSDzxD/2nUAqE6SZCA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:nx27yQnZI+0=;WGL2mren5CSbvnJN3BrJHsAi/Yo JT1mxozShu39GTIMz7BY6f05XVIRujnt6MuekpazrPtoRxGBJ+Hy3ky8b3Hk7pHY0faStoEix 6Rb8GCDYF0dXly2smQS4WCGRpQ9Db0lv1IYcBMivKhFOSaorPGn2UX/iuSouOmscm7ngCL5LI osqdvQI8OAEJvKvFMzwl4zRuk/fsSX0CPr5Z5iJHfzTU39Q0Wy/oXR4DLzZVT8Wfhje81wnGu bX1wQ1dO1i1MnmVb2FMyl2nNq1zBLWtBDoM599Fg4bTmQO6ARLVjXD9uxF+B+GW4WdI+zizDS gNNYTeKvBSxmTYXVohFREyRHn6TmT1Z7NXwP5oIe+vfwex/4dOb4Pg6QF4W+cAXwwm51jJcfC 7m7pgcFx9pycKKwB3ux9lfmugGeq6P1hiuT9VLCV2dmEgDgKtGzC8duxp5SNcEX972fM3qwh3 UwrAtbCP1p/JVDZqTxe9GV4CKnQTpEs4nUOseNBoIPUrXdRDAS72LmQyg3vAVeMbg+5mzhFtF HaA1HSikfgKkV9vm3w4SHTRKCt56ub265NL075Z6DUYKwK8NcbFyg+CMfWhvGByEo4hPUf+Br K+kmRZ2+ZkWO9LrR2Dj4a4onlqO+R/XTFAGxSgBv8m9D+BGWkQ2Nm7NWr1cntL8DLaAc5D6+x OHeBD6MqjWZ3t8NsoUrmY2IZZlheR9/61KsXNZfxjbQz7ot3ibK60O7orn5eEVvCr7GckDhtZ DoeXHdEAmn1q0v+SOa5lWBq5272oyXYvEy6lolql0ERGL8cnXi6OI8s1mCGgk3CeQjH4p31l2 vP90caWvJUyW62zxOFuCIw7A== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.