Re: [PATCH v1] Fix tab completion for REINDEX SYSTEM

> On Oct 23, 2026, at 21:39, Sho Ito <i(dot)sho(dot)0628(at)gmail(dot)com> wrote:
>
> Hi,
>
> psql currently offers `CONCURRENTLY` after `REINDEX SYSTEM`, although
> the backend rejects that combination [1].
>
> The attached patch completes only database names after `REINDEX SYSTEM`,
> including when parenthesized options are present.
>
> [1] https://github.com/postgres/postgres/blob/3138f248cd3de43dd0f96760fc666152ea8a5c37/src/backend/commands/indexcmds.c#L3317-L3321
>
> Kind regards,
> Sho Ito
>
> --
> ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
> Sho Ito (Sean)
>
> E-mail: i(dot)sho(dot)0628(at)gmail(dot)com
> LinkedIn: https://www.linkedin.com/in/sho-ito-0628/
> GitHub: https://github.com/sean0628/
> ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
> <v1-0001-Fix-tab-completion-for-REINDEX-SYSTEM.patch>

LGTM. My local tests also show that v1 preserves the existing behavior for REINDEX DATABASE while removing the unsupported CONCURRENTLY suggestion for REINDEX SYSTEM.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/