postgres.git / summary / log / commit / refs

commit    70f90a103c80c9a0db3ace858d4fcad0b4dff4bc
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Jul 27 18:13:15 2017 +0000

    Fix psql tab completion for CREATE USER MAPPING.
    
    After typing CREATE USER M..., it would not fill in MAPPING FOR,
    even though that was clearly intended behavior.
    
    Jeff Janes
    
    Discussion: https://postgr.es/m/CAMkU=1wo2iQ6jWnN=egqOb5NxEPn0PpANEtKHr3uPooQ+nYPtw@mail.gmail.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 17583357601..06f09d50d52 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -676,7 +676,7 @@ static const pgsql_thing_t words_after_create[] = {
 	{"UNIQUE", NULL, NULL, THING_NO_DROP},		/* for CREATE UNIQUE INDEX ... */
 	{"UNLOGGED", NULL, NULL, THING_NO_DROP},	/* for CREATE UNLOGGED TABLE
 												 * ... */
-	{"USER", Query_for_list_of_roles},
+	{"USER", Query_for_list_of_roles " UNION SELECT 'MAPPING FOR'"},
 	{"USER MAPPING FOR", NULL, NULL},
 	{"VIEW", NULL, &Query_for_list_of_views},
 	{NULL}						/* end of list */


[parent: 51b76f974176]