postgres.git / summary / log / commit / refs

commit    db5a703bf69d6302d0d515a9068baebffd2d227e
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Tue Aug 18 16:49:04 2015 +0000
First released in: 9.6.0, 9.5.0

    psql: Make EXECUTE PROCEDURE tab completion a bit narrower.
    
    If the user has typed GRANT EXECUTE, the correct completion is "ON",
    not "PROCEDURE".
    
    Daniel Verite


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

diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 62cb721cc25..816deda1cf8 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -2622,6 +2622,7 @@ psql_completion(const char *text, int start, int end)
 		COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_views, NULL);
 	/* complete CREATE TRIGGER ... EXECUTE with PROCEDURE */
 	else if (pg_strcasecmp(prev_wd, "EXECUTE") == 0 &&
+			 !(pg_strcasecmp(prev2_wd, "GRANT") == 0 && prev3_wd[0] == '\0') &&
 			 prev2_wd[0] != '\0')
 		COMPLETE_WITH_CONST("PROCEDURE");
 


[parent: d3eaab3ef0d5]