public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rob Sargent <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: Wim Rouquart <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: [email protected]
Subject: Re: Index (primary key) corrupt?
Date: Sat, 20 Sep 2025 13:16:40 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>



> On Sep 20, 2025, at 9:58 AM, Adrian Klaver <[email protected]> wrote:
> 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.eurpr...
> 
> "
> > 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
> [email protected]

I don’t see the complete REINDEX command used but from the output of the query on pg_index it looks like reindex using index name would succeed, no? Again assuming this was done against the dump which may or may not have matched a grep attempt. Lord knows I’ve had my share of false negatives with grep. 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Index (primary key) corrupt?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox