Feedback-ID: i76984098:Fastmail
Message-ID: <92999289-f47b-46ac-8867-9fa08041e2ac@aklaver.com>
Date: Sat, 20 Sep 2025 09:58:02 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index (primary key) corrupt?
To: Rob Sargent <robjsargent@gmail.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Wim Rouquart <wim.rouquart@kbc.be>, Ron Johnson
 <ronljohnsonjr@gmail.com>, pgsql-general@lists.postgresql.org
References: <CAKFQuwYvNQoYt+ESUkDMBRpejXdW6PYk6D8LTCsOsCGC6j4eOQ@mail.gmail.com>
 <8BCB3E64-990E-44A9-A0BB-079CC4C43820@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <8BCB3E64-990E-44A9-A0BB-079CC4C43820@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/92999289-f47b-46ac-8867-9fa08041e2ac%40aklaver.com>
Precedence: bulk

On 9/20/25 09:26, Rob Sargent wrote:
> 
>> So the problem goes away once you’ve reindexed yet you claim it’s consistent? What are you doing to get the problem to recur after you’ve done reindex to make it work?
>>
>> David
> 
> I was assuming the OP has  a dump of the affected condition and is restoring (and perhaps re-fixing).  No?

 From this post:

https://www.postgresql.org/message-id/AS2PR05MB107548567EEDAAB3AF74A6C59EF11A%40AS2PR05MB10754.eurprd05.prod.outlook.com

"
 > Is the PK definition in the pg_dump file? For plain text format can 
you grep/find it?


It is in neither, that’s why I'm sure it doesn't get exported. After a 
REINDEX statement it is.


 >How is the dump file being restored?


As the code to generate the index is not in the dumpfile this seems 
irrelevant to me.
"

Make of that what you will.


-- 
Adrian Klaver
adrian.klaver@aklaver.com