Re: psql tab completion bug for ALL IN TABLESPACE

On Mon, Dec 14, 2015 at 8:49 PM, Andres Freund <andres@anarazel.de> wrote:
> On 2015-12-14 20:44:20 +0900, Michael Paquier wrote:
>> +     /*
>> +      * ALTER TABLE,INDEX,MATERIALIZED VIEW ALL IN TABLESPACE xxx OWNED BY xxx
>> +      * SET TABLESPACE.
>> +      */
>> +     else if (pg_strcasecmp(prev9_wd, "ALL") == 0 &&
>> +                      pg_strcasecmp(prev8_wd, "IN") == 0 &&
>> +                      pg_strcasecmp(prev7_wd, "TABLESPACE") == 0 &&
>> +                      pg_strcasecmp(prev5_wd, "OWNED") == 0 &&
>> +                      pg_strcasecmp(prev4_wd, "BY") == 0 &&
>> +                      pg_strcasecmp(prev2_wd, "SET") == 0 &&
>> +                      pg_strcasecmp(prev_wd, "TABLESPACE") == 0)
>> +     {
>> +             COMPLETE_WITH_QUERY(Query_for_list_of_tablespaces);
>> +     }
>
> Isn't that already handled by the normal SET TABLESPACE case?

No, There is no SET TABLESPACE case, there is a TABLE SET TABLESPACE
though. Just removing the TABLE seems to be fine..
-- 
Michael