postgres.git / summary / log / commit / refs

commit    3cf2f7af7f9b6198f3d518aaffb0ff4de340c5bc
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Mon Oct 24 06:46:42 2022 +0000

    Improve tab completion for ALTER STATISTICS <name> SET in psql
    
    The code was completing this pattern with a list of settable characters,
    and it was possible to reach this state after completing a "ALTER
    STATISTICS <name>" with SET.
    
    Author: Vignesh C
    Discussion: https://postgr.es/m/CALDaNm2HHF_371o+EeSjxDDS17Cx7d-ko2h1fLU94=ob=4_ktg@mail.gmail.com


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

diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 584d9d5ae64..a64571215b3 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -2216,6 +2216,9 @@ psql_completion(const char *text, int start, int end)
 	/* ALTER STATISTICS <name> */
 	else if (Matches("ALTER", "STATISTICS", MatchAny))
 		COMPLETE_WITH("OWNER TO", "RENAME TO", "SET SCHEMA", "SET STATISTICS");
+	/* ALTER STATISTICS <name> SET */
+	else if (Matches("ALTER", "STATISTICS", MatchAny, "SET"))
+		COMPLETE_WITH("SCHEMA", "STATISTICS");
 
 	/* ALTER TRIGGER <name>, add ON */
 	else if (Matches("ALTER", "TRIGGER", MatchAny))


[parent: 14a737bfdbe4]