Feedback-ID: i76984098:Fastmail
Message-ID: <0868c260-9812-4629-b32d-026c1fe6089f@aklaver.com>
Date: Fri, 6 Mar 2026 08:03:07 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index (primary key) corrupt?
To: Wim Rouquart <wim.rouquart@kbc.be>,
 Greg Sabino Mullane <htamfids@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <AS2PR05MB107549DDE42DC0B8E31CB52BFEF90A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <5043ff13-2f39-4a80-a8f8-6765746b6a89@aklaver.com>
 <AS2PR05MB10754EE81F34146EE8972713EEF91A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <58221272-d684-4799-a113-d5a5031a0b05@aklaver.com>
 <AS2PR05MB107541E760AECB8639BB968B5EF63A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <fd548bde-54d3-426a-a2b6-058750cfb554@aklaver.com>
 <AS2PR05MB1075432E74AF2FA975B02519AEF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <b1fec029-b8fb-4177-a01a-9457e813ce68@aklaver.com>
 <AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <25b5291f-a3d3-4655-a3d3-57f28b70ec5a@aklaver.com>
 <AS2PR05MB107546C1B04FC4B3CCF32E60CEF7DA@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <78328b08-249e-4251-8a10-b5dac183442a@aklaver.com>
 <DB5PR05MB107646FFE78759D1D5431F802EF7AA@DB5PR05MB10764.eurprd05.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <DB5PR05MB107646FFE78759D1D5431F802EF7AA@DB5PR05MB10764.eurprd05.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/0868c260-9812-4629-b32d-026c1fe6089f%40aklaver.com>
Precedence: bulk

On 3/6/26 2:31 AM, Wim Rouquart wrote:
> Internal
> 

> 
>> As I recall this is not a large table, but for completeness what is it's average size?
> 
> It has only 12 rows 😊
> 
>> What are the Postgres log settings, on the source database, for?:
> 
> log_error_verbosity = 'default'
> log_min_error_statement = 'fatal'
> log_min_messages = 'warning'
> log_statement = 'ddl'
> 
>> Are there any entries in the Postgres log that reference this table?
> 
> Nope, none found, probably because it isn't used anymore (and because of above log settings if it would be)
> 

Well at this point I don't see that it is possible to determine a cause 
for why the index does not transfer or throw an error in the process.
-- 
Adrian Klaver
adrian.klaver@aklaver.com