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 1ts12T-00DGNo-PA for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 14:57:01 +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 1ts12S-000FnZ-Ha for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 14:57:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ts12R-000FnG-Kj for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 14:57:00 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ts12P-002FEe-0W for pgsql-general@postgresql.org; Tue, 11 Mar 2025 14:56:58 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.stl.internal (Postfix) with ESMTP id 3D0152540146; Tue, 11 Mar 2025 10:56:56 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Tue, 11 Mar 2025 10:56:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1741705016; x=1741791416; bh=lSy4PGSqS9g2qrRris4wXOMN+24oXQuD2YXAxrQEWII=; b= P6WcOaQ0AelGvhbGDnkY0QjAO24Mik11BGMb04BYKOmVWhLQ2me8mnewR458Yeb+ kcSp8vdgG65yzAa/mBnCZWC7Fg1EA87VIht7ndAc5iOhb30aATJjBPcHhLtmmQ0L UPPgOTEg6Z9IdA2jI3kgrAjXR/+Sb2YsvyhC+TyAmx0GD4zjqBOw9RrZN6pq75pt beDbK5PzAP9I4tgphYqT/DwQkYUi1Nsyt3ERGDno9AeiJ24WhEUr5WnETbV6alHd z2+6T+qUIMb6n0TAvefvRKcaKvRm+eeHV7g1h5xHyyWtyDtfIk+VHM2BqQY8MLYV A5OeeGycz1sNHNDSfelm4A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1741705016; x= 1741791416; bh=lSy4PGSqS9g2qrRris4wXOMN+24oXQuD2YXAxrQEWII=; b=k NKwkHb7x+wRFO4CZb2A00uJMjhz5gD/u5Fbx5SFeZewHg3lcs/o33w2JL1/eFyoh LqkDPLXVx7/9DAaguNmG8e4iSWLVEZKNIeZ7YoRbUYKvEKFnVDsxgNZI/RzXRC6N Pl7mDmePR8KCDA2ZUhsgjfEsyXgOTFToOZuWpj9Jmy+LcNQDoNwMEgsNaTjX1a1M 787l4dxXDNi8i59XEgW1Tm3N75hm2fQVWYCfl+XnRjxa2LiQovu9vpHae3xIPw37 B35vkG4ApB8G15ndkL3Cl2JWNw4dFKL98+Q2hjClx2aeBfkLOY54TzuXWdL1Eq5A 2U2Uaj+lf9E9/2E3mFOaw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduvddvhedvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff ggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhirghnucfmlhgr vhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtf frrghtthgvrhhnpedvhfffhffffeehueetfefgiedujeevjeffgfetfeehfeetgeegleek veevffffkeenucffohhmrghinheppggrmhgriihonhdrtghomhdprghmrgiiohhnrdgtoh hmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggu rhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvd dpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepmhgrrhhksghrrgguhihjuhesohhu thhlohhokhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehpohhsth hgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 11 Mar 2025 10:56:55 -0400 (EDT) Message-ID: Date: Tue, 11 Mar 2025 07:56:54 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Duplicate Key Values To: mark bradley Cc: pgsql-general References: <36356aa1-1a5c-44af-a1c0-f190249812ca@aklaver.com> <6aee94f9-d421-4622-bccc-bdac37969be0@aklaver.com> <75b33741-ee99-4524-b63a-edad21c1266d@aklaver.com> <9d919848-3fe1-46fd-b343-c5f2931864f7@aklaver.com> <513ddbee-135c-4af2-b6f6-acca667b8d09@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/11/25 07:28, mark bradley wrote: > An "interesting" effect of reindexing is that all the records that were > dups in the nodes table were deleted, both copies. I am trying to understand above. Was there at least one row of each node_id left? > > Also, all rows having node_id as a foreign key in other tables were > deleted, which means all rows in these tables were deleted. > > Fortunately these are not huge tables.  I will reenter the data, make a > backup, and then try your further extended suggestions. > > Best regards, > Mark Brady > _amazon.com/author/markjbrady _ -- Adrian Klaver adrian.klaver@aklaver.com