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 1ts1Lp-00DJRL-I6 for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:17: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 1ts1Lo-000glY-A9 for pgsql-general@arkaria.postgresql.org; Tue, 11 Mar 2025 15:17: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 1ts1Ln-000ghb-Fi for pgsql-general@lists.postgresql.org; Tue, 11 Mar 2025 15:16:59 +0000 Received: from mail-dm6nam10olkn2080.outbound.protection.outlook.com ([40.92.41.80] helo=NAM10-DM6-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 1ts1Lj-002FNs-2U for pgsql-general@postgresql.org; Tue, 11 Mar 2025 15:16:56 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=P3sKMCxwagbZUUk175D+nIUNM3EQpn5pfutwOuYEf33JYhMyzoh3m6r8fLRj6/JTIqRHFX0p3cxEdvx9erK0U9vfbLHrpTc0/HWbYWPg14+9jH+UINRqrWgyGw4vnLh3vaq5HfnL7gYe9Fqv6Tlq8ziAb4oYA2W0/iCrtoX71nqZEXqISr4+r3wr2j+z3vbcYBfNifQ9n8XOeSZiFL11eiMsB+9/A/5CbpvumDZd4PbnhG/7yJOzb/LZI+2ZWWAlMvU/zZL73Qmv856w2F9I4cJXYMIsso4nXwI2/e+YoUmGA4fx/eoCjvd2QpFmXAGXgAcNX2MzHl3Q71D/948tYg== 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=5H/VRQh4KxfZ7BVspGcUYWlIqcj36cHeWv81QA8ZTSY=; b=sgV2teDW6qjEIXODah0Xi0GrwdeVbt7jYJAS7vBMFRy4TRdn/jCA/8RoU2lruyV41KBdW2YuLo0mW+S9JolzaQ9Jjt3mfCNc/RruTuJEmE+Eo1GHkgyyhIHNcfNWF1xGuo7LEHgcOBca6xDbWafL8f41TJpC2fOVn0sqNrIr3ebE63X3J+NtkEwUNZkSV6Yj1Maa7uDjmrGPnuGl5VMgdjj6Q4RoS5PUuEVVOvXKbeFzT4JlUJrgaoRsolFmF9xNyblGfYmTtLk6FiuVr12vOu8LCfApUlk3N4Je5DlIgIxjRy/o3LV069javackaIV27bYgfmoTTj+IlZ1ioQECAA== 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=5H/VRQh4KxfZ7BVspGcUYWlIqcj36cHeWv81QA8ZTSY=; b=NP3x5+1/2iz02/q/dVrd5wJo1U4Dl49bj5uNuumKfZWjJplm70jSKYPQcz0J97p0CSoCz2r+x7UI5XeJu3mdAGoVjho/lkvnmcH555npCR2Y5tPrvtAZtAxuGumMOzGJ5zT7UtThxVr0YrMsa9JE0zB+Zlg42xyglUM2pghOit4kxuGFld859hur6ptfuGkp9TkKryL1yaUw9GrQp4k1b3fgT2mWPHsHRxt1WtRStwdIFIOqAObDmbgNB2OreIfL8wtZhqLv7y7NwYGajsp7lk5TdFTbAvdwfkbCVOKDyD9oqbi4tnJp5nz2feTr6086ly7C7bgAPAdEV1/hAh6hzg== Received: from SJ2PR22MB4328.namprd22.prod.outlook.com (2603:10b6:a03:547::6) by SJ2PR22MB4460.namprd22.prod.outlook.com (2603:10b6:a03:55f::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8511.27; Tue, 11 Mar 2025 15:16:52 +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:16:52 +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+imAABowgIAAQNjvgAAKxYCABeQlYIAACUYAgAACETqAAAJXAIAAALnD Date: Tue, 11 Mar 2025 15:16:52 +0000 Message-ID: References: <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_|SJ2PR22MB4460:EE_ x-ms-office365-filtering-correlation-id: 6e7136d2-cced-49c4-2cb2-08dd60afc0c2 x-microsoft-antispam: BCL:0;ARA:14566002|19110799003|8062599003|7092599003|15080799006|9400799030|12050799009|461199028|15030799003|8060799006|41001999003|1602099012|10035399004|440099028|102099032|3412199025|4302099013; x-microsoft-antispam-message-info: =?us-ascii?Q?rPmk5oIWmCubEjJbtk55FbanWF2fSgDXi3jgZeY8sUGeqUYppmAhhA2DJBaP?= =?us-ascii?Q?VOuPf+Ykw35c1W2Pz7D9JzdPxXOIW2fo165WkqtjotfCloj9bLt79Y2ph2Cx?= =?us-ascii?Q?GicfhRwBCkAfmmaGIVirRG+d9ZMmps+BP/857MZksugqCVeSPJu+Zt4B4kZ+?= =?us-ascii?Q?6hNKB/YWre1ioS17R9eqhx04rxwbnPCLMGgkol53SsxRWTbaxXVEZf1my+kr?= =?us-ascii?Q?u4/467wFA79NdfsuoxGr+ZLnTT8No5YWoL6fx0faLwOQ4d+7XoU/Aq5KAfO1?= =?us-ascii?Q?rwdURILsZ3m9bUuX0zXsCXPtNEAJzH6KhNNd8g29iEjKr82qjz5cpKWrvQNf?= =?us-ascii?Q?3xV0hdGx86T4+5pd2AHE4Z2SqSxS4GO0Mxil3+sxW2BJw9Vok6BnEGeauKnR?= =?us-ascii?Q?KYqKdwq7AJgehPtPBt6yRWdLmeO5fgqrWav8dnXSOnVGNgJoBmj2e5UBAI1R?= =?us-ascii?Q?xlBczhdUI3aCdAsGNN1rOp0aoQ7snCIuMh7a8+3mncq84ZqCp3sADg2Lz7Am?= =?us-ascii?Q?QLerssGkfNlSNtzzXEQZQp7XDVlSg1b3geMms2AP64Ys7+dy11uE+qel7Md6?= =?us-ascii?Q?PZnHexR4s6q53GK04Vix9IZKsEthsZA/WRD55keQI9XW7ta59dadOL6E3io7?= =?us-ascii?Q?o5ATfYTmEjPeCOGlg17wv0aevSCEjXlF4xFscMcCiJGSSWBrdGtxiEHh/qIP?= =?us-ascii?Q?DeaztCApVBurLDwaJ3Sb0GBhY/Z/vyaH2vm/EasHIcTudq0keP6cEMgMIH7r?= =?us-ascii?Q?+/oCdtLnFXd783Wpgflc4k7nBztq1GlXO0zPt8ZO/lDhfOE84b+NwwZkq/Um?= =?us-ascii?Q?jgDd662jLmkdL57rZVLD4+/47JkdYwLmr9mS74mwaFRdUGuZeUr7EOst6+rm?= =?us-ascii?Q?NHxNr7fcUCsJLKKpiNzFtBgzGt0v+oF3s7m5mab2f+GY/F6g5yenOy36WC4l?= =?us-ascii?Q?gzcyYTs1+oHpjunVUjHxVx6M8LbIQ7dTvoK3LIrq63mUURxzOriw4sRlfRbB?= =?us-ascii?Q?OrH8ziI6OVIke/ygeJGIAmq6FCPhGf9tbrQHhNXHQ6wc83v1JWEABWFl1g1Y?= =?us-ascii?Q?hhoTqP4GMJs5aJVDTJ+aRrOQIYOBm7rerf05p1YqgzQdlUOXjNcInvOOzzM0?= =?us-ascii?Q?6O2J9s2Q2Ms/7ybBO9lU/5N9XuIlAPuH11KlfUWiR314BtA1TjNwEHBjZBTu?= =?us-ascii?Q?CPkq2B2u5af/FUnEaL+kDV35osq+Ev099ZQ7mKzMbom2vgCKUFQv5pScWk6y?= =?us-ascii?Q?059ODHI2pEh1rZ2h5yU89Jmq25pUS3kOHCT2F/Z/T7Vl+cCofvgVXVO4XH8q?= =?us-ascii?Q?p0SKtMvAr+09L3m9sEAzO/ZJ?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?nRKNX8L1Sf2DRMSDCgagWr7qFh94Rl8aiOiDGK1D5izg0ZFCpSzh35YYS771?= =?us-ascii?Q?dQ+qIpe3yGhTB2lC0tKdxBQYQUT/Vipm/mdIqQWqRkbAUhjnCy8k37T9HqUM?= =?us-ascii?Q?d3ifuNRk9oGVw9wpPBO68pcAIDsYwdqoJ2FW5Qgdb4/+TBHlQmOoO2t95vXS?= =?us-ascii?Q?q6SkihzTnVjqyLzhZWZxFnHKPL9BoR/NOZOiW6gUrA7Lat+pAMDb1WCiuhD5?= =?us-ascii?Q?H9doGE9rqm0rRTsBwO1ztA1LgfhBrRsRGvP/ygYuqkgw+3eEOZ/QkSY5AKcm?= =?us-ascii?Q?iCGCUvfNqcm6MiICFbXQM2o+4TUFAmleeGsf9bywt1uJGbVp0vMDoPnQdmDl?= =?us-ascii?Q?rJa/l7b8zMWY091td00GFibM/vy/8BTAc0kyHgn0dXNVedc17FMO7ws72uVm?= =?us-ascii?Q?tmfLGoudph7rDA25ZSlknId/UcTV8HIUHHRJKqU/LJufmgObvdSt1EoYiPl1?= =?us-ascii?Q?LHSwkAs6J+Ck6T1nZCKv4QUo/48Z8ioeC48MAFa+CmqASGOY9cd4imvRVX+D?= =?us-ascii?Q?hBFZdVie8HhBQhebm0u3WPS5pRC+h24IcuMqJN+cIl+1T9uT4lz87brLLIPi?= =?us-ascii?Q?op8YJmDOnnxQXw/RRTa9B5pF9ghha5GOnK0tqhSaF6YOrUkibpQ0jpCpG9Zy?= =?us-ascii?Q?0ijMkr0O/gafptXU9HP7FdFIw7UszxHIdfnOL8wzFt14RJv7AMW9F+gF97J/?= =?us-ascii?Q?pZY3NH1fb+oFSMspeBsEfETFRbDqbcz5LHSbzmnMdf0sinCRLKYQeuBeLtCK?= =?us-ascii?Q?fmWiGzlIomU8MyMo30Gyfp2VPXcEXMyBGx5DnOWt6IWwZIgUWhjyibMWaU2h?= =?us-ascii?Q?3C+g9yxHoFKcZlbVk3kMLyKmkUYqfLKAHGKCa7Y0aRtZS1X90rj6ouhOZGFu?= =?us-ascii?Q?3buvVNGQmNb+aAXcz/GlGtrYIrohw4XjY+z1L+sw9MuhFsuukVpJkd/lvSMy?= =?us-ascii?Q?NahXMAN+fOi5PxlXw2gfzZ91RdzzB/L389jAzg6rpVGg1OytKu8rc2VpXS/q?= =?us-ascii?Q?cnJtgqkVIu1yFC+im/qtV5gzQuQ7czOIzSoqfpARmJSI/O2p0r3SSvgJBB9M?= =?us-ascii?Q?ym09zKVQwCGQxT3wgZM8RT1wwJKtdbspbClhGwCjzc2A8WIs3XDqR380hWZs?= =?us-ascii?Q?mj5x/bDz4x517Gwvxc4MtWp7fnXuMx4hegl48aRt+g9VThxfnawwhGBOWnKt?= =?us-ascii?Q?acuBQJqWwpn/5iwSLrG3MqSvyxzjD6tF0gNKqyOVmIRzmB6T+ilZMUTIgrM?= =?us-ascii?Q?=3D?= Content-Type: multipart/alternative; boundary="_000_SJ2PR22MB4328A3EDC83E495DB9A4BD09BAD12SJ2PR22MB4328namp_" 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: 6e7136d2-cced-49c4-2cb2-08dd60afc0c2 X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Mar 2025 15:16:52.5696 (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: SJ2PR22MB4460 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SJ2PR22MB4328A3EDC83E495DB9A4BD09BAD12SJ2PR22MB4328namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable b REINDEX TABLE node; Also reindexed table with node_id as a foreign key in the same way. Best regards, Mark Brady amazon.com/author/markjbrady ________________________________ From: Adrian Klaver Sent: Tuesday, March 11, 2025 11:12 AM To: mark bradley Cc: pgsql-general Subject: Re: Duplicate Key Values On 3/11/25 08:05, mark bradley wrote: > The rows that were preserved in the nodes table were the ones that were > not dups originally. 1) To be specific: a) If there where two or more rows with a node_id, after the reindexing was there only one left? b) Or for any node_ids that where duplicated did reindexing eliminate all rows with that node_id. 2) Per post from Greg Sabino Mullane, you need to show us the steps you took to reindex the table. > > > 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 > -- Adrian Klaver adrian.klaver@aklaver.com --_000_SJ2PR22MB4328A3EDC83E495DB9A4BD09BAD12SJ2PR22MB4328namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
b

REINDEX TABLE node;

Also reindexed table with node_id as a foreign key in the same way. &n= bsp;


Best regards,
Mark Brady
From: Adrian Klaver <adr= ian.klaver@aklaver.com>
Sent: Tuesday, March 11, 2025 11:12 AM
To: mark bradley <markbradyju@outlook.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Duplicate Key Values
 
On 3/11/25 08:05, mark bradley wrote:
> The rows that were preserved in the nodes table were the ones that wer= e
> not dups originally.

1) To be specific:

a) If there where two or more rows with a node_id, after the reindexing was there only one left?

b) Or for any node_ids that where duplicated did reindexing eliminate
all rows with that node_id.


2) Per post from Greg Sabino Mullane, you need to show us the steps you took to reindex the table.

>
>
> Best regards,
> Mark Brady
> _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
> ----------------------------------------------------------------------= --
> *From:* Adrian Klaver <adrian.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 re= cords 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 wer= e
>> deleted, which means all rows in these tables were deleted.
>>
>> Fortunately these are not huge tables.  I will reenter the da= ta, make a
>> backup, and then try your further extended suggestions.
>>
>> Best regards,
>> Mark Brady
>> _amazon.com/author/markjbrady <https://amazon.= com/author/markjbrady
> <https://amazon.co= m/author/markjbrady>>_
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

--
Adrian Klaver
adrian.klaver@aklaver.com

--_000_SJ2PR22MB4328A3EDC83E495DB9A4BD09BAD12SJ2PR22MB4328namp_--