Horton

Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value

Sergei Kornilov <sk@zsrv.org>

View thread
From: Sergei Kornilov <sk@zsrv.org>
To: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: Nikita Malakhov <hukutoc@gmail.com>, pgsql-hackers@postgresql.org
Date: 2023-07-10T18:39:41Z
Lists: pgsql-hackers

Commits

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

  1. Add pg_column_toast_chunk_id().

Hello

My +1 to have such a function in core or in some contrib at least (pg_surgery? amcheck?).

In the past, more than once I needed to find a damaged tuple knowing only chunk id and toastrelid. This feature would help a lot.

regards, Sergei