Horton
Menu

Re: BUG #18016: REINDEX TABLE failure

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: richard.vesely@softea.sk, pgsql-bugs@lists.postgresql.org
Date: 2023-07-08T00:17:21Z
Lists: pgsql-bugs, pgsql-hackers 
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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Reindex toast before its main relation in reindex_relation()

  2. Fix comment in index.c

  3. Clean up a bug in sql/json items commit 66ea94e8e6

  4. Create a "relation mapping" infrastructure to support changing the relfilenodes