postgres.git / summary / log / commit / refs

commit    157adfdf4adc83c2779de234a415eeb4d1bbb38c
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 b5d49ea40da..90d950b2364 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -921,7 +921,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: a2fc3431c355]