Add missed case for tab completion of GRANT/REVOKE MAINTAIN.

tglsfdc · tglsfdc · commit 9e1e9d6560ec · 2023-04-19T10:49:53.000-04:00
We failed to offer "ON" after "GRANT MAINTAIN". Oversight in commit 60684dd. Ken Kato Discussion: https://postgr.es/m/6afe7712991882a864d6d10003264e7c@oss.nttdata.com
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
@@ -3902,7 +3902,7 @@ psql_completion(const char *text, int start, int end)
 	else if (TailMatches("GRANT|REVOKE", MatchAny) ||
 			 TailMatches("REVOKE", "GRANT", "OPTION", "FOR", MatchAny))
 	{
-		if (TailMatches("SELECT|INSERT|UPDATE|DELETE|TRUNCATE|REFERENCES|TRIGGER|CREATE|CONNECT|TEMPORARY|TEMP|EXECUTE|USAGE|ALL"))
+		if (TailMatches("SELECT|INSERT|UPDATE|DELETE|TRUNCATE|REFERENCES|TRIGGER|CREATE|CONNECT|TEMPORARY|TEMP|EXECUTE|USAGE|MAINTAIN|ALL"))
 			COMPLETE_WITH("ON");
 		else if (TailMatches("GRANT", MatchAny))
 			COMPLETE_WITH("TO");

Original file line number	Diff line number	Diff line change
`@@ -3902,7 +3902,7 @@ psql_completion(const char *text, int start, int end)`
`3902`	`3902`	`else if (TailMatches("GRANT\|REVOKE", MatchAny) \|\|`
`3903`	`3903`	`TailMatches("REVOKE", "GRANT", "OPTION", "FOR", MatchAny))`
`3904`	`3904`	`{`
`3905`		`- if (TailMatches("SELECT\|INSERT\|UPDATE\|DELETE\|TRUNCATE\|REFERENCES\|TRIGGER\|CREATE\|CONNECT\|TEMPORARY\|TEMP\|EXECUTE\|USAGE\|ALL"))`
	`3905`	`+ if (TailMatches("SELECT\|INSERT\|UPDATE\|DELETE\|TRUNCATE\|REFERENCES\|TRIGGER\|CREATE\|CONNECT\|TEMPORARY\|TEMP\|EXECUTE\|USAGE\|MAINTAIN\|ALL"))`
`3906`	`3906`	`COMPLETE_WITH("ON");`
`3907`	`3907`	`else if (TailMatches("GRANT", MatchAny))`
`3908`	`3908`	`COMPLETE_WITH("TO");`