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