RE: Index (primary key) corrupt?

From: Wim Rouquart <wim(dot)rouquart(at)kbc(dot)be>
To: Rob Sargent <robjsargent(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Index (primary key) corrupt?
Date: 2025-10-10 12:30:04
Message-ID: AS2PR05MB107546562E71D13C3771E8AFBEFEFA@AS2PR05MB10754.eurprd05.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Internal

Yes indeed, i just restore the database to before the rebuild.

> 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?

>

Disclaimer <https://www.kbc.com/KBCmailDisclaimer>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-10-10 15:03:04 Re: Index (primary key) corrupt?
Previous Message Wim Rouquart 2025-10-10 12:28:28 RE: Index (primary key) corrupt?