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.eurprd05.prod.outlook.com
"
> 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]
