Horton
Menu

RE: Index (primary key) corrupt?

Wim Rouquart <wim.rouquart@kbc.be>

View thread
From: Wim Rouquart <wim.rouquart@kbc.be>
To: Rob Sargent <robjsargent@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-10-10T12:30:04Z
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>