pgsql: psql: Fix tab completion for DROP INDEX CONCURRENTLY

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql: Fix tab completion for DROP INDEX CONCURRENTLY
Date: 2026-10-22 02:01:38
Message-ID: E1xJi7e-00000000Gaw-2onF@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

psql: Fix tab completion for DROP INDEX CONCURRENTLY

psql offered CASCADE after DROP INDEX CONCURRENTLY and an index name,
even though CASCADE is not supported with CONCURRENTLY. Offer only
RESTRICT in this case, while retaining both CASCADE and RESTRICT
for ordinary DROP INDEX.

Backpatch to all supported versions.

Author: Sho Ito <i(dot)sho(dot)0628(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Reviewed-by: Shihao Zhong <zhong950419(at)gmail(dot)com>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAG7L5+7KXgvJUGCGXzyQrt7UysC9iytaYzx-7YyQTFYXjHVTWQ@mail.gmail.com
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fbb9d76aa0582051af3a87a3b4200365bc409535

Modified Files
--------------
src/bin/psql/tab-complete.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2026-10-22 02:01:49 pgsql: psql: Fix tab completion for DROP INDEX CONCURRENTLY
Previous Message Fujii Masao 2026-10-22 02:01:28 pgsql: psql: Fix tab completion for DROP INDEX CONCURRENTLY