postgres.git / summary / log / commit / refs

commit    8d304072a2573f0bfbdf893cc79197aeecdb5242
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 e9fdc908c71..e34922dd731 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -1056,7 +1056,7 @@ static const pgsql_thing_t words_after_create[] = {
 															 * INDEX ... */
 	{"UNLOGGED", NULL, NULL, THING_NO_DROP | THING_NO_ALTER},	/* 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: 77cb4a1d6730]