Re: Index (primary key) corrupt? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Index (primary key) corrupt?
Date
Msg-id CAKAnmmLsxdt51sp-w0JxMi0haGXHFKD2pXURfOSOa5iVzjni4w@mail.gmail.com
Whole thread
In response to RE: Index (primary key) corrupt?  (Wim Rouquart <wim.rouquart@kbc.be>)
Responses Re: Index (primary key) corrupt?
List pgsql-general
On Mon, Mar 9, 2026 at 10:12 AM Wim Rouquart <wim.rouquart@kbc.be> wrote:
I already saw finding the actual cause as a 'lost cause' as these things tend to happen, however what bothers me most is that a tool like amcheck which is supposed to find corruption also shows up with no result.

Well, no, these things really should not happen. :) 

It may be too late, but it would be real interesting to see this query both before and after the REINDEX:

select * from pg_index where indrelid  = 'bcf_work_type'::regclass and indisprimary;

An incorrect indrelid is one way I can think of as to how pg_dump would miss it, but that wouldn't explain why reindex would subsequently fix it.

 
Cheers,
Greg

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Index (primary key) corrupt?
Next
From: Adrian Klaver
Date:
Subject: Re: Index (primary key) corrupt?