Re: Add IS_INDEX macro to brin and gist index

On Fri, 16 Jan 2026 at 09:55, Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
> On 2026-Jan-16, Japin Li wrote:
>
>> Thanks for the test. After rethinking, I agree — that BRIN/GIST index-type
>> check is useless.
>>
>> OTOH, why don't we just do it the same way as the btree index functions?
>>
>> brin_page_items(relname text, blkno bigint);
>
> Operational usefulness. If you have a corrupt page in a production, you
> can extract it from there with get_raw_page() and move it to another
> system to do low-level investigation. If you only have the interface
> you suggest, you force the researcher to access the production system
> (and run potentially dangerous tools), which may be best avoided.
>

Sorry, I didn't get your mind. We can still use get_raw_page().
> --
> Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

--
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.