Fix tab completion for ALTER LANGUAGE in psql
authorMichael Paquier <michael@paquier.xyz>
Mon, 5 Aug 2019 05:30:27 +0000 (14:30 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 5 Aug 2019 05:30:27 +0000 (14:30 +0900)
OWNER_TO was used for the completion, which is not a supported grammar,
but OWNER TO is.

This error has been introduced by d37b816, so backpatch down to 9.6.

Author: Alexander Lakhin
Discussion: https://postgr.es/m/7ab243e0-116d-3e44-d120-76b3df7abefd@gmail.com
Backpatch-through: 9.6

src/bin/psql/tab-complete.c

index d47384295871a980dcaac7675883d53ca94e03c2..d4aa4d22abe4b85c437720efdaf88ff6938bce1f 100644 (file)
@@ -1676,7 +1676,7 @@ psql_completion(const char *text, int start, int end)
 
    /* ALTER LANGUAGE <name> */
    else if (Matches3("ALTER", "LANGUAGE", MatchAny))
-       COMPLETE_WITH_LIST2("OWNER_TO", "RENAME TO");
+       COMPLETE_WITH_LIST2("OWNER TO", "RENAME TO");
 
    /* ALTER LARGE OBJECT <oid> */
    else if (Matches4("ALTER", "LARGE", "OBJECT", MatchAny))