Re: psql tab completion bug for ALL IN TABLESPACE

On Mon, Dec 14, 2015 at 8:49 PM, Andres Freund <andres(at)anarazel(dot)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