Re: Add missing tab completion for VACUUM and ANALYZE with ONLY option

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Umar Hayat <postgresql(dot)wizard(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add missing tab completion for VACUUM and ANALYZE with ONLY option
Date: 2025-02-27 06:12:37
Message-ID: CALDaNm1Jsoo4___61K-3JFBfywtv=juWO9wdMkmzKAcUSiyY=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 6 Feb 2025 at 16:29, Umar Hayat <postgresql(dot)wizard(at)gmail(dot)com> wrote:
>
> Hi,
> Recently the ONLY option is introduced [1] for VACUUM and ANALYZE
> commands. Attach provides improved tab completion for this new option
> for both commands.
>
> Along with this also added starting parenthesis "(" auto-complete as
> multiple existing commands provide it and it makes it easier to
> separate command options (VERBOSE, FREEZE, ... ) from table list.

This will include "ONLY" also when we display the tables too:
+ else if (HeadMatches("ANALYZE"))
+
COMPLETE_WITH_SCHEMA_QUERY_PLUS(Query_for_list_of_analyzables,
"ONLY");

like below:
postgres=# analyze only t1
information_schema. ONLY public. t1

The same issue exists with vacuum too:
postgres=# vacuum only t1
information_schema. ONLY public. t1

Regards,
Vignesh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2025-02-27 06:34:24 Remove unused <poll.h> header file in pqcomm.c
Previous Message Maxim Orlov 2025-02-27 06:11:12 Re: Spinlock can be released twice in procsignal.c