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

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
To: pgsql-hackers@lists.postgresql.org, vignesh C <vignesh21@gmail.com>, postgresql.wizard@gmail.com
Date: 2025-03-18T15:13:21Z
Lists: pgsql-hackers
On 18.03.2025 17:57, Ilia Evdokimov wrote:
> Hi,
>
> Thank you for the patch. However, Is it ok if I can't tab 'ONLY' in 
> VACUUM ANALYZE command?
>
> CREATE TABLE only_parted (a int, b text) PARTITION BY LIST (a);
> CREATE TABLE only_parted1 PARTITION OF only_parted FOR VALUES IN (1);
> INSERT INTO only_parted VALUES (1, 'a');
>
> VACUUM ANALYZE {Press Tab}
>
> information_schema.  only_parted          only_parted1 public.
>
> ----------------------------------------------------------------------------- 
>
>
> Although it works:
>
> postgres=# VACUUM ANALYZE ONLY only_parted;
> WARNING:  VACUUM ONLY of partitioned table "only_parted" has no effect
> VACUUM
> postgres=#
>
> -- 
> Best regards,
> Ilia Evdokimov,
> Tantor Labs LLC.
>

Umar, Vignesh, sorry for not adding you to CC earlier!

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.




Commits

  1. psql: Add tab completion for VACUUM and ANALYZE ... ONLY option.