public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Rob Sargent <[email protected]>
To: 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 09:58:02 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAKFQuwYvNQoYt+ESUkDMBRpejXdW6PYk6D8LTCsOsCGC6j4eOQ@mail.gmail.com>
<[email protected]>
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]
view thread (5+ messages)
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