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 1ts1AW-00DHhI-Hn for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:05:20 +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 1ts1AV-000PYy-8C for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:05:19 +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 1ts1AU-000PYo-Lm for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 15:05:18 +0000 Received: from mail-mw2nam12olkn2080f.outbound.protection.outlook.com ([2a01:111:f403:2805::80f] helo=NAM12-MW2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ts1AS-002FIP-0G for pgsql-general@postgresql.org; Tue, 11 Mar 2025 15:05:17 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=CSefBeg5sJO55G0/3xl2rgoXarr8lQDY9sMtUIRp9KdxaBA23IJCNIhOxUBHVYFj1BiIRYr1A0u43G21ZiYKsbR7HqZRM7B9Q4Enp/ZMarKnt6Eclexs0paf7aSh4JxDsE75C5lWFsLZNmykRmUpvVq3hxQShM3igNV0RiFwuDOLBy/aR/wUsHvpOC6Pk7dNQHGI9HzepBGV/38fsqy1T64EitMGTkPkTj/CJCFq+IEXTpfhVhtvYXLVJuUFD1qKVboxCELGSQXuX7SOgjAYKMBQLNV1o8YGRSzw2O3GaJTI2JPqxLsRClGjyNkbV0OFXHzreF07PkzZwtc+SfwbGg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=HNM8IGERujItDK/ujdbMqhy+uP4o2K5x3ZV7J6neR9c=; b=QeUEZyYhPgo/YdKMH6+hlL+axL4QhYd7JTRoSrh1Xaj3RL1r7MkJfM6asDLdJEAuP2s8EvePmvCTVVrItsKmMy9In2l/mteSnxoe3bly7oxNUrjnkvr6HKgNQUVK0wWB9Aqdr+ba4qbWDxk6N3slOlkkwzfIv43Ks5wIbfZO0jQ+uec0QcNEjdCAT2yH8rgR57rhe0/1xxHSmf/pdILLh7hv2Oo6Ue9uKDmRZYFvv4voOa2px1tXA+4jSA2L2bK3HgSmWCmqi9HdBgh8I6oiLUzcQXIGSj3RfvkMhVeU9t/fgNByg+HaKLNWg2hRywC656vJfTB/CEFHbd+tSc62tQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=HNM8IGERujItDK/ujdbMqhy+uP4o2K5x3ZV7J6neR9c=; b=V8YTr/w9paa4oJYGuaCE7X2LbHuyLGvOFtxaYj5+kdMzV3/Fgf9JeYLC1ySuQGaHTkz2L/pZuKZhe+AuzTXZg2Nx1B0Rt1SNChfpS6eEBgRiu2DUIhYSp/CaCqw/MNASKQQUht7X87Xxi6UCm50XpZBkBb58wsOmF0Nwk4jUvldJYnPKTaZ2//vjIdCrgZH8+jz6G7AYANyuRr1d5afAEMzmDLBTCPZXpQpU3hxDaAYy7E9REvo760Z56Tk49kCjs0CyShQo4YWy4DKDY84upvfhVK0g1cprrVTBrwiWA6ynalZXHAZDLC+uIx38efzH8nerihEgbBEJNUI9HlSmAA== Received: from SJ2PR22MB4328.namprd22.prod.outlook.com (2603:10b6:a03:547::6) by CH3PR22MB4244.namprd22.prod.outlook.com (2603:10b6:610:17f::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8534.21; Tue, 11 Mar 2025 15:05:12 +0000 Received: from SJ2PR22MB4328.namprd22.prod.outlook.com ([fe80::2440:4b5e:d794:94e]) by SJ2PR22MB4328.namprd22.prod.outlook.com ([fe80::2440:4b5e:d794:94e%6]) with mapi id 15.20.8534.017; Tue, 11 Mar 2025 15:05:12 +0000 From: mark bradley To: Adrian Klaver CC: pgsql-general Subject: Re: Duplicate Key Values Thread-Topic: Duplicate Key Values Thread-Index: AQHbjfSQTi8IT+qnIE+vrsDEftWknrNk0i6AgABZWESAAAeigIAAA0qAgAEyu6OAAAQ9gIAACBsIgAAUTYCAAACl9oAACBWAgAEp+imAABowgIAAQNjvgAAKxYCABeQlYIAACUYAgAACETo= Date: Tue, 11 Mar 2025 15:05:12 +0000 Message-ID: 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> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SJ2PR22MB4328:EE_|CH3PR22MB4244:EE_ x-ms-office365-filtering-correlation-id: a5e7cc13-b745-4dad-62e4-08dd60ae1f5f x-microsoft-antispam: BCL:0;ARA:14566002|12050799009|8060799006|9400799030|15080799006|19110799003|461199028|7092599003|8062599003|15030799003|102099032|1602099012|3412199025|440099028|4302099013|10035399004|41001999003; x-microsoft-antispam-message-info: =?us-ascii?Q?Y1X6oH8Pxa5VoM9S5GZqoOtsYVLNGJnCM1EBQjhumAk4M2pDXDMjvLarH5k6?= =?us-ascii?Q?TWRaB/pjuWSBzQAjcbKIEZfY81p3N7sOrWbJtiRB418cjAsUK0+lU54Qkv8i?= =?us-ascii?Q?tIcZIvXv6D1S3rlGdZdPsdQnAOt4KZ71bKwz68zD+UWh1sz7stInjTTIl9Tr?= =?us-ascii?Q?hwUk337cpK9aSu53ZWiyl+gXglfChen79z16c4aj7s82akJ8JGZk3SgopCPh?= =?us-ascii?Q?BrcDPZjQRyG8ECG/GAuNRfouxqiescYaGHgY1tItMd9JJbt0WoL5wUhiOwY3?= =?us-ascii?Q?23+1Yd5pbjNVWPU0h/s+y4yZc55XW55dY4j8OTxlABd02bEiliSp01EoJ0PY?= =?us-ascii?Q?/cjgejJX5YxRUeSHZA7USbkUyrXctFs7oofTyJdbQItCzhXn8FtDEv1qRFtg?= =?us-ascii?Q?a87oO5ic0wDeJHzGveh+2HFYy0y7W+3EnHZS1UYkVR4+007yfdPoqB7AG1j+?= =?us-ascii?Q?fCmR0/2OlMf5qyIdzIDuPqy1S8Qeuwb0KlhBC1rhnKrh8ozDJhq030LJI8Pt?= =?us-ascii?Q?0TPg32QaTj545O8eLVHYMHOuGF70HXZzkPQOoqgBZWU/wL9tcM58Yqs5xqMk?= =?us-ascii?Q?90myccDe9FDU17Wgd8reUttHmZMMQ9UJ9FNM+xX4pdqmJ2L/h6/PyC0ckbOE?= =?us-ascii?Q?pdIcdPVl7vxA79XNV+YVPELBsFVILF0fkLNuw7HwSG7f42xZAgJUpSr0je6G?= =?us-ascii?Q?fn4el65BBC8tcU5N/6g6E0OJ6wa87nw0m1+gheHu0U5ex6nMDyBYClM6SEfE?= =?us-ascii?Q?YxZbgkUCJ7h9PbKYtrikBJqMM7LPTL7CqihJZEYmQqrpImp1u3QfKfyH5PZs?= =?us-ascii?Q?6qGsK0eZH64s4cQBkdwp5vhNMY473L+Nm3ivkxYhDRcfvuUr2Cj0QBdAVQnB?= =?us-ascii?Q?7LTxlifUq8M0n59ZVHKinvApMzP604vleZzUbf6ytoHh6jYZ93wxU2vidmQt?= =?us-ascii?Q?KXCiC6lad1HOfQT0ldnQGkKUSOvYRtlrNeEN1scuqI+C+3UvXPkv+uT3W59T?= =?us-ascii?Q?GPqJtWnbucxi8ZFOCQUSE4AcZsWMlzyKn7Xuur4/EWpI1yM15lzvJ8wkIfFN?= =?us-ascii?Q?dtH2DVKyLt8RGWYvty1yx4Zd8zI91PwGtvG9B8aax6gV7tgI+CPXQgiFyNmf?= =?us-ascii?Q?1ri/CzcKppmSoPGTNZNopH9Qmyst/Ksr7i//8W1vfR5x3kzFwU2q6VyfPty+?= =?us-ascii?Q?mrnnkIVBI7oeTr4i42ZzAQGH7KZp290ULmDJZz2waiXGFN+8tKn2e4Mz92EC?= =?us-ascii?Q?Ke32G9QHIA1FtY9TEBMfDY3Jvt0pZtLJG6ikkXmN9qG7kYlqEqo1yqkNXgHy?= =?us-ascii?Q?64d7bjtC88Hy4ontOj1tPTk+?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?2Bpv8aJyuQKHcuhIFhp8/C9YkwymjmHRDaSAkYMOSTxzwu1RXGaAOQ8vXWqf?= =?us-ascii?Q?kfdUeMZIDeioyuMcsYzAhrJ0vI3xM5ou2sv43WdjTCZuNIUStMs6pumP/qIM?= =?us-ascii?Q?CWVt8DFZoUyPhnyr4W+bPjYs78O3n0YQcnUXgvrc+hSwPAFJlbGyya7f1T8K?= =?us-ascii?Q?EAQCxhPZhPAYsiFyXxRjwKg4y3X5okMHe17B1hpzi81gQfKTLvdOXkLNU/jG?= =?us-ascii?Q?1/5xiQzHLTHvQDGX50jIWv9s8Ej2BOddvQGtqQ9doLHdkPNbjt7+MRzOi8+K?= =?us-ascii?Q?Hl3tJh9kWGR58EgKGKl+tNQwpT7ooSLtbpJ5HsHH7C162cnHC6TiZY87FMlh?= =?us-ascii?Q?1XuQ0h2NEZeMDqo1sN1giNEQCIkewaRNrOQ9iS608oedkPtPcFj5rE45vlY2?= =?us-ascii?Q?E/qheMldUNhSgIvimxHG0BYhSYIxRYNCxcdXZq84n/78ZWjx8Th0AXmgwfGP?= =?us-ascii?Q?J2OkaGAKPCxNA/MTOgBiVaycWN7/3tg8hc3QnNQgGYpd+m5b6KI1j2TYt+30?= =?us-ascii?Q?+douLi6yoIh9vopekr3QD8DjNiEGJIXCNcH0tUC2rlMCj6kSJoxvtcCrswa5?= =?us-ascii?Q?UsjdRUy1+t2hzxo/9AG6Xizsijb9TUICINQHrrU4eBKIfTVMpcw6T+YZUY/B?= =?us-ascii?Q?xRoeyh4wv8FMtRBwOowBeQgpTFA1q2P2JBbaYjEBK0GPf4sv8bH9Y0kDXsJu?= =?us-ascii?Q?cGivoSiHeBHfupwmdSALySy0LAb/JRBON+Pk5WQocTc+Uo1MK1a06MQuQlZf?= =?us-ascii?Q?fkXsC9Ah2qAvZq8W6t0AVsqBqD6sEBE0w9bwXbI2PX6BHPSED0gETdIEafCA?= =?us-ascii?Q?iU0FQiC93BvcHaYoZtpK+Ya/R1uOJnRJzQHIWS1Pwhh4WhhH/uNxeIs8Ft06?= =?us-ascii?Q?ld1ndeqCFH9kBxHIwABfrMe2HML7mNKKGClQ7q526R7mvt3dER06lA/CPr/+?= =?us-ascii?Q?ThFkF/yCfoKi4uRIUdD/TgzRKoYMWExf9+oljwxZNnCzdXVUsv6r6UKfdVEg?= =?us-ascii?Q?WexX+DLeXT4NPSq+USsgTCQby2Ujap6bKB36QhzlPBbSeHkl6LcR0TcBc43p?= =?us-ascii?Q?AlN3Um2HkGiSOvWkM1ehLEQa+wxFxEpvLpfKlA2pIERvFPXnmpYOzPhAeLWu?= =?us-ascii?Q?x/kN49ViRkRbTbqfJ4UeiEsR9d7R12UCuH4PT9drb6D0DgGdhulaFD27rdZj?= =?us-ascii?Q?BfQ66O/qGe7ZSDCEDVzOsviW0R5PSXsgrCRgr8BCajqTV10sWfMCvv3zIz0?= =?us-ascii?Q?=3D?= Content-Type: multipart/alternative; boundary="_000_SJ2PR22MB4328267BD9F601D90601715BBAD12SJ2PR22MB4328namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SJ2PR22MB4328.namprd22.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: a5e7cc13-b745-4dad-62e4-08dd60ae1f5f X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Mar 2025 15:05:12.3192 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH3PR22MB4244 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SJ2PR22MB4328267BD9F601D90601715BBAD12SJ2PR22MB4328namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable The rows that were preserved in the nodes table were the ones that were not= dups originally. Best regards, Mark Brady amazon.com/author/markjbrady ________________________________ From: Adrian Klaver Sent: Tuesday, March 11, 2025 10:56 AM To: mark bradley Cc: pgsql-general Subject: Re: Duplicate Key Values 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 --_000_SJ2PR22MB4328267BD9F601D90601715BBAD12SJ2PR22MB4328namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
The rows that were preserved in the nodes table were the ones that were not= dups originally.  


Best regards,
Mark Brady
From: Adrian Klaver <adr= ian.klaver@aklaver.com>
Sent: Tuesday, March 11, 2025 10:56 AM
To: mark bradley <markbradyju@outlook.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Duplicate Key Values
 
On 3/11/25 07:28, mark bradley wrote:
> An "interesting" effect of reindexing is that all the record= s 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 <https://amazon.com/author/markjbrady>_


--
Adrian Klaver
adrian.klaver@aklaver.com

--_000_SJ2PR22MB4328267BD9F601D90601715BBAD12SJ2PR22MB4328namp_--