Re: BUG #18016: REINDEX TABLE failure - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #18016: REINDEX TABLE failure
Date
Msg-id ZKirERBzkM48E0op@paquier.xyz
Whole thread Raw
In response to BUG #18016: REINDEX TABLE failure  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18016: REINDEX TABLE failure
List pgsql-bugs
On Thu, Jul 06, 2023 at 08:29:19PM +0000, PG Bug reporting form wrote:
> Given a table with a TOASTed variable length attribute, REINDEX TABLE fails
> to rebuild indexes when you truncate (or otherwise corrupt) relation files
> for both TOAST table index and a custom index on the varlena.

Could you clarify what you have done here?  Did you manipulate the
physical files in the data folder before running the REINDEX commands
you expected should work?  There are many things that can go wrong if
you do anything like that.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files
Next
From: Tom Lane
Date:
Subject: Re: BUG #18016: REINDEX TABLE failure