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
torecur 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
adrian.klaver@aklaver.com
