postgres.git / summary / log / commit / refs

commit    9e1e9d6560ec60535289ac15729a08e2f7cf4165
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Apr 19 14:49:53 2023 +0000
First released in: master (reverted before release)
Reverted by: 957445996fda (in 16.0), 151c22deee66 (in 17.0)

    Add missed case for tab completion of GRANT/REVOKE MAINTAIN.
    
    We failed to offer "ON" after "GRANT MAINTAIN".
    Oversight in commit 60684dd83.
    
    Ken Kato
    
    Discussion: https://postgr.es/m/6afe7712991882a864d6d10003264e7c@oss.nttdata.com


 src/bin/psql/tab-complete.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 5825b2a1954..bd042449691 100644
--- 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");


[parent: 0b5d1fb36add]