Re: psql: Make tab completion work for ANALYZE VERBOSE ...

Greg Sabino Mullane wrote:
> Quick patch to fix the fact that the EXPLAIN ANALYZE VERBOSE is clobbering
> tab-completion for ANALYZE VERBOSE.

Thanks.

> *** tab-complete.c    24 Feb 2009 10:06:34 -0000    1.180
> --- tab-complete.c    27 Mar 2009 01:29:06 -0000
> ***************
> *** 1627,1633 ****
>       else if (pg_strcasecmp(prev_wd, "VERBOSE") == 0 &&
>                pg_strcasecmp(prev3_wd, "VACUUM") != 0 &&
>                pg_strcasecmp(prev4_wd, "VACUUM") != 0 &&
> !              (pg_strcasecmp(prev2_wd, "ANALYZE") == 0 ||
>                 pg_strcasecmp(prev2_wd, "EXPLAIN") == 0))
>       {
>           static const char *const list_EXPLAIN[] =
> --- 1627,1634 ----
>       else if (pg_strcasecmp(prev_wd, "VERBOSE") == 0 &&
>                pg_strcasecmp(prev3_wd, "VACUUM") != 0 &&
>                pg_strcasecmp(prev4_wd, "VACUUM") != 0 &&
> !              ((pg_strcasecmp(prev2_wd, "ANALYZE") == 0 && 
> !                pg_strcasecmp(prev3_wd, "EXPLAIN") == 0) ||
>                 pg_strcasecmp(prev2_wd, "EXPLAIN") == 0))
>       {
>           static const char *const list_EXPLAIN[] =

I find that that particular rule is formatted differently than the 
others. It took me a while to figure out how it works. All the others 
check the keywords from left to right, but this checks that the previous 
word is VERBOSE and works to the left from there, kind of. I also don't 
understand why the explicit check for VACUUM is there. It only makes a 
difference if you write something like "VACUUM EXPLAIN VERBOSE", which 
isn't valid. I guess it was needed before this fix to not match "VACUUM 
ANALYZE", but isn't anymore.

I'd suggest to write it like this:

>     else if ((pg_strcasecmp(prev2_wd, "EXPLAIN") == 0 &&
>               pg_strcasecmp(prev_wd, "VERBOSE") == 0) ||
>              (pg_strcasecmp(prev3_wd, "EXPLAIN") == 0 &&
>               pg_strcasecmp(prev2_wd, "ANALYZE") == 0 &&
>               pg_strcasecmp(prev_wd, "VERBOSE") == 0))


While we're at it, any idea what the logic behind this rule is:

>     else if ((pg_strcasecmp(prev_wd, "ANALYZE") == 0 &&
>               pg_strcasecmp(prev2_wd, "VERBOSE") == 0) ||
>              (pg_strcasecmp(prev_wd, "VERBOSE") == 0 &&
>               pg_strcasecmp(prev2_wd, "ANALYZE") == 0))
>         COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables, NULL);

? The first part of that I understand, "ANALYZE VERBOSE", but "VERBOSE 
ANALYZE" isn't valid SQL.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com