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 1v7CGA-00GUoQ-J9 for pgsql-general@arkaria.postgresql.org; Fri, 10 Oct 2025 12:30:10 +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 1v7CG8-00C98i-Bn for pgsql-general@arkaria.postgresql.org; Fri, 10 Oct 2025 12:30:09 +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 1v7CG7-00C98Z-Vn for pgsql-general@lists.postgresql.org; Fri, 10 Oct 2025 12:30:08 +0000 Received: from mail60.mailinfra.com ([193.244.253.162]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v7CG6-001PoP-24 for pgsql-general@lists.postgresql.org; Fri, 10 Oct 2025 12:30:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kbc.be; s=selector-aaa; t=1760099406; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version:content-transfer-encoding; bh=8DKhHDA3S4eJGj5PrEBOMyfNkGxbA45ldg1aynOqVcY=; b=olkEs16KsaML7vZYOdHxG/FJ2G4/4MlM10mMhJNXZEbbtx9rgdDuni4T RhLM/OKmU65b55fNV08rcsB5UhzNBK3Pgr/Fdcz2wgtK2yjW5dqEMCFkD x0Kt3XmPXap0TPZ+mS2HRzCjpw+v3OfT9A1o9rtGfe6yYxrSX/+fs6a8/ SGiW4nBKXuiqJfSKtBWiy5IKKtDL0WFU0hd4LypXZXTRpq0BmZUfxHgDe KiyKWZu7YOtFr40Mezf6Zsgg1XK+7F/9QB6DZ3bmDQ6qsE2fjmu8vrB6W r9Y/5hvDoF8isINm/a8Ah39wpuLaFaWwZQe7i1eLvDkA35hJaG1jQC9TY w==; X-CSE-ConnectionGUID: j1l5o9BoRnWhIkhGrO2t5w== X-CSE-MsgGUID: pQ9zLZPGR6qmicxuae8BFg== X-interpillar: False X-massmail: False X-trusted-saas: False Received: from mail113.mailinfra.com ([193.244.104.21]) by mail68.mailinfra.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 Oct 2025 14:30:06 +0200 Received: from AM0PR02CU008.outbound.protection.outlook.com (mail-westeuropeazon11013067.outbound.protection.outlook.com [52.101.72.67]) by mail113.mailinfra.com (Postfix) with ESMTPS id 22A5C600092; Fri, 10 Oct 2025 14:30:06 +0200 (CEST) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=KboYeU2z3lM3vhS1jD2FFyuvTm1c+LzvP3UmchkcstYCo8UdoHA3z9+FWx6gtW+tasYZ8JjPh0oUmwx2LiZfof/0qto6P7YgVpoEspsqMkmAGtwvoCEwXAPUIA00qOMnNyclEt7FYczFAKxggeCEQ/bh4zvGcnEvN3WEw35TjdrO0p+eiTxE1fNFCDccI6bHZHFG5X+U0dmEZX8B9vGkBpR75v1ppFs7aMkNKwhhNDopiabqJuyxYNx5DlcvXOgbDVC6Ntjd8wkdHq4eeE/Dr4mq0vcFQSjJO/1mda6KqNb79V6TerdtdhQL3+DUifjWyKG2Za0pom4shntPsGKUaQ== 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=eucM+MbQQs/jgDuINsfaIyFAZ/GpSGUdYpnnAaqk7M8=; b=yspVRlQbLviBg2dP1fsBvGvrXudFJQw9UHGKWJJExnJTD+c3AutJd/SKedNLMFOx6u+ylYWJ5XBVassVsLXw4xekGblh/ALv9OHR/DiJCGqVFgI+BjsTdOM3mh3CNNTKvPweSiS7MOhuvhhB6iF2H0JlkByAMycbWTXZv5SqwS3oKdBG8LRWrnGMSJ1PLSo0mAm/OO9oyrL9fEpc/49w2WGauv0ekZdEC9poOLhi64B1L24UlSv09sArU03IbbhKbfSAGSZurKdJXAe3cnEDX6H6VUVSzSZo3NdMDZy2o8C8SnwnbUGVCdVtKyfLw9MqZqljwlIg37sSCxcGBcdQeg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=kbc.be; dmarc=pass action=none header.from=kbc.be; dkim=pass header.d=kbc.be; arc=none Received: from AS2PR05MB10754.eurprd05.prod.outlook.com (2603:10a6:20b:64c::7) by DU4PR05MB12122.eurprd05.prod.outlook.com (2603:10a6:10:61d::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9203.10; Fri, 10 Oct 2025 12:30:05 +0000 Received: from AS2PR05MB10754.eurprd05.prod.outlook.com ([fe80::ba3:5eb5:f53d:9644]) by AS2PR05MB10754.eurprd05.prod.outlook.com ([fe80::ba3:5eb5:f53d:9644%6]) with mapi id 15.20.9203.009; Fri, 10 Oct 2025 12:30:05 +0000 From: Wim Rouquart To: Rob Sargent , "David G. Johnston" CC: Ron Johnson , "pgsql-general@lists.postgresql.org" Subject: RE: Index (primary key) corrupt? Thread-Topic: Index (primary key) corrupt? Thread-Index: Adwol1a+rcvHuOuQQceM5FEl8oW9YQAHJfAAACN9f7AAQCutAAACM2qAA+WFI8A= Date: Fri, 10 Oct 2025 12:30:04 +0000 Message-ID: References: <8BCB3E64-990E-44A9-A0BB-079CC4C43820@gmail.com> In-Reply-To: <8BCB3E64-990E-44A9-A0BB-079CC4C43820@gmail.com> Accept-Language: nl-BE, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_Enabled=True;MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_SiteId=64af2aee-7d6c-49ac-a409-192d3fee73b8;MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_SetDate=2025-10-10T12:29:01.0000000Z;MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_Name=d44a7eb9-e308-4cb8-ad88-b50d70445f3a;MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_ContentBits=3;MSIP_Label_d44a7eb9-e308-4cb8-ad88-b50d70445f3a_Method=Standard authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=kbc.be; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS2PR05MB10754:EE_|DU4PR05MB12122:EE_ x-ms-office365-filtering-correlation-id: 2e255e7e-7f27-4ebf-524f-08de07f8bdcb x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|19092799006|366016|38070700021; x-microsoft-antispam-message-info: =?utf-8?B?NTFqT1NJNU96bVRQRDl1L1drbWdBTUQvRUFrRzEzS2EyWkhneThVajJZNU5N?= =?utf-8?B?OSt2TUhDdU9zcE9ZdXJNWWRJU29GRXZ5UFNIL3EzWmlEUnlzUmRKeXN3Rmdi?= =?utf-8?B?dUVFV3F6VmdoT2dYWVJ6RG0vM0RCUEVXeUNVNDFhZ1B1VkNQVHNtQkh5bWl2?= =?utf-8?B?WWZHY2RMNjVpWkpHUUc1WTJaa2MwWkNNaXpUa0Q2SHcyckdNaHRETGZZbFVH?= =?utf-8?B?dllxR3dJMERVN2NXYTk1UUxMU3pUM2N6dkFsRnlCdHVtbVJXeSszWWE0SXZT?= =?utf-8?B?a1lFRVpHbVpmTkNJOXJRWHNQQkFncVZhRWxBQlpGZXV6d3hVTzhWUDQrZDFh?= =?utf-8?B?Zkl2VmVNbGJ1Q1MvQ0d2cEtVV1FKSjdKajUxa1hUQWtYMFI1VjlnVURvV2RQ?= =?utf-8?B?QkM0bm5xOVhRdVQyQUJpTFAwRTFaRHBRaHhPQUxvWnN5dy85ZjU0ajl3azhu?= =?utf-8?B?ZytOMnU1clZrRHVET3hsWHRDZW1oQk1uZFI2emJyMWNaZnJXQmNNTTgrcUtr?= =?utf-8?B?ZzAzeVh3Z20vN0tVcE54d2s5RDlvYjZiaGYrVWhzem5PdGlHNTNSbU56SXdi?= =?utf-8?B?ZDl5aDVsK09SVkNzRjd5cmJ6NHppTUN5VEs1T0orQXU0ejk2ZllxY1lKcHpz?= =?utf-8?B?a2pLMUszeFZVRkNycDdjUW5tRnZ1c0lTUDJLb3lXWVNneGF2d0Mrc2lKQkUx?= =?utf-8?B?ZldKcXhEZGl0dEdtZDZoa0N0S0RJR2ViVDlGZ2dqWEYyMVcrMzQ3ekFYMkZp?= =?utf-8?B?Rm45NHVaZGswZ2UvQm1YK0swcE9vcTFwdTdRQ2FQV0NnQ2xxenM2SnBzVEdG?= =?utf-8?B?UzVPTStFajJ3YlV5cEN1OVByb1Z3eG1YSmlRbHVzOUNDaVRGVEk4UEVzeTQ3?= =?utf-8?B?WTZGbmgrR1lnd2dVYTl6a0NKanJlazVQbkRqUE55Z25kWkZKWGtPcE1uSmc1?= =?utf-8?B?VW1rRzRiVWdFem91L2RjWHlpVVFMVC95dHdsSStMbnZDb2NuWVpFYmlPZ1pa?= =?utf-8?B?QysxMk0xUzJzRHovMVpFTDVpcmZBOE1EWGVLby9DZDBOY3hPMVBQM2p0eDFr?= =?utf-8?B?Y1E4bTRPemFGL2tCVkFVcGJ1R29pSTJ0MmlHSml5c3daNURTQTZIbzVVYlEw?= =?utf-8?B?SlhJTTdEeW0vODBXMkc1cTFwM2dyYmxhSytxRmEybjBEUzR6RUU3alJTaW1X?= =?utf-8?B?MHQ0RE8yMjhhcC9INTV6c0JjcXlFbXR4OHRqc1Bvb0w1a0VUamhJSythcXRo?= =?utf-8?B?Z3Y3SzM2NitGSEVMYnh1ZWduU3JUYUxuOEY5dEd2dEdvWHNNTzRrRWFUTEtZ?= =?utf-8?B?UU1mVGpLUWY3Qk43RGFBUXlMYjhSSXJUVWVtdUJEVWdCSzRrTkliNTBZTXNT?= =?utf-8?B?YW5yMFBSK0U3K1lud2dlUzZuSUswdUFCVXhIWmJwelpvM3RhZE1XRFNURE1o?= =?utf-8?B?dTkxamwwWGkxTjl6bktudkJtanJDZnJKb0JMR1M3alRoeTZEaEd5aTZuMmVR?= =?utf-8?B?WktRWUwzQzlNL3BpTjEzL01vYzdKNWVHankvUnlJNU42QzFTTUxKQ3FZMW83?= =?utf-8?B?TjVMTWZTcENCT05Ycm1ZNXFZNGNLY3R1WUlJNFROQllwUGVDQXNEOS91RGtq?= =?utf-8?B?VFRyUXlJM2hSR3ZGT2RQRDhVOGVydFJ2V1l6UWRvWThybGtUc0YzRXJ6OHlj?= =?utf-8?B?Ym01N3I0bm15QTdTdkNDaWwzNFpNRi91cEJoeU5ibXprc2p3dWNCQ0ZiUmta?= =?utf-8?B?QWtwRmtCaWk2WVVRb1pMOFZPU0FESGxEZEp2OEpIdFp2c0tYSWl0SzBRYVVy?= =?utf-8?B?Y3kvZ0pOcEU2dmpQQW5mTGJlNHk2bVRUeERkbHlLRmlZSkFkUkYxS3A3QVBD?= =?utf-8?B?eVBydWhoMU1yTGhheUdxNE92MFh0dXM0eitHVmxlajViUS9haW9Kdk5MaTJt?= =?utf-8?B?WTRaZFJYM0Q2RHNhSTJId294NXJEMVhzdGZvTWdudzRnYlZGNExTcHFlTVQy?= =?utf-8?B?VzAweitab2hUZGZQVkJYaFJwZFovenpwMkxkd0VxRms2eUJENHZzNmwyQmEw?= =?utf-8?Q?vCScCe?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS2PR05MB10754.eurprd05.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(19092799006)(366016)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?WG9MbmdpcjJseU5uMGJPaHlJZWpCUmhmOGx1NWp2V3c1ZXRMSnd5YnJMVkhL?= =?utf-8?B?RFVTMWhxcWlqZ2VKUmcxaEQwcGdKYU5ETlN6TVQxVDRadDJyNHdlNEVsdFZE?= =?utf-8?B?Nm9aMjlNSSt4QW9pMks2alJnQ1VPMjZxSHNkKzQ0VGxPdkFtc1QwUHVmYnU1?= =?utf-8?B?NGwrZUR0UlFuZ1RIcVlLZTJWZ05SNWE2TUI0d3VORVJWY1FwUVYzcURabDU4?= =?utf-8?B?NHBvaE1kZDRHM2h3ZFpVSEY4WEhtNllFVXdybDRZVUdkTGVmdmIxV2F1UU5v?= =?utf-8?B?enRQWGhoOFNZS0VrQnlkcXJkSWtHK0l2K3l0RWxmaEh2b2UvaXhUcmFIWFRz?= =?utf-8?B?Vlh4eGtWRkFNWXBVNkpsaHkwY3p4NGg5ZlRPY1FLUjhKalVwZXdsZ2JKbVRG?= =?utf-8?B?eFM2bVVOTEVYUkNDeXVVRWJTVkN3MERrL1JVSjRiYnd6RjFscTRROWtwSkJK?= =?utf-8?B?aXlSN2hWWFZaN0VxdUJrQlpQUE4zQ2Z4UWVEaFRKbFRPVHhkWGlTQ2VnVitz?= =?utf-8?B?S25aZng5ajdhNU9OQUNkV1FMSDBOZEN0L0lrd0Y5SXY0SUZsVmJaczBkQis4?= =?utf-8?B?MXVBRmk0cFBHLzZvWnE2bmxOTUJsaDJVZmxpNDFMc3dnMFRhZ0RPZjhVZGZ1?= =?utf-8?B?QWdlbGcrb29IOFpLcEJqbkNqRHc0N08raVVXVkFIbTllMXhUQmo1NE5PdWxK?= =?utf-8?B?Um5JUFFBWUpyUWNYQlI0NjlBb3o1MGgwZVpsai9xUFZjMFNQUzM1L2JwQVZo?= =?utf-8?B?M0tocDdVc1NNOWlNYUlRNzJ3N2dZcEJmV0pTRG91RkhpZWRQQ0FLOVhkK2FV?= =?utf-8?B?WUZRQ09SNEo3YkV6UmNMVzhiRXZONmJFb2d4ampiVlppeTg5WDJvNTdQcDZR?= =?utf-8?B?ZTNBVmlBOU5BWWFBUDNkZFhoeVRQdkxQdUlKOWNrNEp5ckhFSG1VUVlEQXQ1?= =?utf-8?B?VkNFRWlhekdBU1NnWEtIZzFYalh3QXp6MlZ6RDd3YW45MXFoR2NtbHdOWEZx?= =?utf-8?B?b3RBaUMydlBETU5BZmJrb1NlSWNiWkdJQjg3T3kybDhIMDM4TUlVWVV5Zk5v?= =?utf-8?B?NTRkQmpSSEt2Wlpwb29FajM1cGQ1NTdqMEFEZ2FiOVVDM3kvQ0hHZjhjV3Y1?= =?utf-8?B?eS9hZnlLYXRDT2g1ZTI2bndRY1o0MEEzaW12YkVUYzRpTURFUm5ySC9GeHlp?= =?utf-8?B?S214ZDdqVkU4bE1hTXhRU2tjTVZ2WFpvM1htSkoxVFFLTGhiZDFySi9XYjgr?= =?utf-8?B?U0c0aktTYi9JMlQrQ2NNWUFXeEYzNWpmdldWWW0zelZ6bTh3NVhpNklpRU5D?= =?utf-8?B?bTBxV2g4c01uZk5VSjNONytGU3E1WTZOb05CMW5iOHZFRi9rRDM1cWxvZ3d0?= =?utf-8?B?THMydXh4d042bkN5WGhKMVZqVUNtZEx0dWdLMVBYajV2UGljb0RhZStmVE5R?= =?utf-8?B?YjNGalZIcThIekRUNmtHRHd1UG9YYkE4NzdBQ21LaWRtSWZ1cnZGZlFvUU9I?= =?utf-8?B?V0RjTTlMMXdMRmxIUGgySG1FU3VvWkYrOHF5RTVVSnpxcGVaN25lNFRrVVQ4?= =?utf-8?B?eHpvc2tWR1hnZjkzVzljTUwwR1QvZ255akk0bFFsbEk4a0dZa0kvR1pXcjU2?= =?utf-8?B?L3l5NStpTDJGbzdiZGl2VHJTbGdpR2Z3SU9jMXk0d29XTVlxTlEzOGlGUWJa?= =?utf-8?B?R3BlNU5xV2x6SUF1aUU1VVFBNGI4ay9lSVo2UXN6VUpOU1M0V040U0xPK1FT?= =?utf-8?B?OHYra28rdnVmeG5FYW1ud0xCblNoL3BYTVl0bXJvQkFqSlREdkdIc2hzR0Js?= =?utf-8?B?RG1xYnVIV244NTRLMy8vdzZmdmlPK0xiZFhJcU52OUhtWGdwUDUrdFpBWVVZ?= =?utf-8?B?MytyQzdnSDBiLzR0SlUxREVKRFZJLzJKbFFsVVFTWjExcE1KR01GcEJiMnYr?= =?utf-8?B?Z0Q0MW5MaUQwcmtIYzNLYkQ3M2hQMUhRWHpSd21zZGtTU282KzJ0NEFYcUVH?= =?utf-8?B?dW9VVGNOd1Z5SWFKbHdPTVN4V3NMeHYwQkZIUytrays0Q2R5eXBYakNNMzUy?= =?utf-8?B?N2NIL3FHekljb3dmd3FIUjBsZUlmZXhXcW9iRE1icVhDMlZkdkRXVEE3bCts?= =?utf-8?Q?k94HxEbVm1eg30Mcy/vXbT5gs?= Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 X-OriginatorOrg: kbc.be X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS2PR05MB10754.eurprd05.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 2e255e7e-7f27-4ebf-524f-08de07f8bdcb X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Oct 2025 12:30:05.0334 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 64af2aee-7d6c-49ac-a409-192d3fee73b8 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: DTEdLdBRzTT0K5BQt0PtQCiLEXk/9nJWHax2PhBAu5GeX6BN5jAwL3WqHNUxdH1ZRqXNiaw8yjEzSYcpWYyeOQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU4PR05MB12122 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SW50ZXJuYWwNCg0KWWVzIGluZGVlZCwgaSBqdXN0IHJlc3RvcmUgdGhlIGRhdGFiYXNlIHRvIGJl Zm9yZSB0aGUgcmVidWlsZC4NCg0KDQoNCg0KPiBTbyB0aGUgcHJvYmxlbSBnb2VzIGF3YXkgb25j ZSB5b3XigJl2ZSByZWluZGV4ZWQgeWV0IHlvdSBjbGFpbSBpdOKAmXMgY29uc2lzdGVudD8gV2hh dCBhcmUgeW91IGRvaW5nIHRvIGdldCB0aGUgcHJvYmxlbSB0byByZWN1ciBhZnRlciB5b3XigJl2 ZSBkb25lIHJlaW5kZXggdG8gbWFrZSBpdCB3b3JrPw0KPg0KPiBEYXZpZA0KDQpJIHdhcyBhc3N1 bWluZyB0aGUgT1AgaGFzICBhIGR1bXAgb2YgdGhlIGFmZmVjdGVkIGNvbmRpdGlvbiBhbmQgaXMg cmVzdG9yaW5nIChhbmQgcGVyaGFwcyByZS1maXhpbmcpLiAgTm8/DQoNCj4NCgpEaXNjbGFpbWVy IDxodHRwczovL3d3dy5rYmMuY29tL0tCQ21haWxEaXNjbGFpbWVyPgo=