NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitc407d54

committed

Add tab completion for ALTER USER/ROLE RESET

Currently tab completion for ALTER USER RESET shows a list of allconfiguration parameters that may be set on a role, irrespectively ofwhich parameters are actually set. This patch improves tab completion tooffer only parameters that are set.Author: Robins TharakanReviewed-By: Tomas VondraDiscussion:https://postgr.es/m/CAEP4nAzqiT6VbVC5r3nq5byLTnPzjniVGzEMpYcnAHQyNzEuaw%40mail.gmail.com

1 parent9df8727 commitc407d54Copy full SHA for c407d54

File tree

1 file changed

-0

lines changed

src/bin/psql
- tab-complete.in.c

1 file changed

-0

lines changed

`‎src/bin/psql/tab-complete.in.c`

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1077,6 +1077,11 @@ Keywords_for_list_of_owner_roles, "PUBLIC"`
`1077`	`1077`	`" FROM pg_catalog.pg_user_mappings "\`
`1078`	`1078`	`" WHERE usename LIKE '%s'"`
`1079`	`1079`
	`1080`	`+#defineQuery_for_list_of_user_vars \`
	`1081`	`+" SELECT pg_catalog.split_part(pg_catalog.unnest(rolconfig),'=',1) "\`
	`1082`	`+" FROM pg_catalog.pg_roles "\`
	`1083`	`+" WHERE rolname LIKE '%s'"`
	`1084`	`+`
`1080`	`1085`	`#defineQuery_for_list_of_access_methods \`
`1081`	`1086`	`" SELECT amname "\`
`1082`	`1087`	`" FROM pg_catalog.pg_am "\`
`@@ -2487,6 +2492,10 @@ match_previous_words(int pattern_id,`
`2487`	`2492`	`"RENAME TO","REPLICATION","RESET","SET","SUPERUSER",`
`2488`	`2493`	`"VALID UNTIL","WITH");`
`2489`	`2494`
	`2495`	`+/* ALTER USER,ROLE <name> RESET */`
	`2496`	`+elseif (Matches("ALTER","USER\|ROLE",MatchAny,"RESET"))`
	`2497`	`+COMPLETE_WITH_QUERY_PLUS(Query_for_list_of_user_vars,"ALL");`
	`2498`	`+`
`2490`	`2499`	`/* ALTER USER,ROLE <name> WITH */`
`2491`	`2500`	`elseif (Matches("ALTER","USER\|ROLE",MatchAny,"WITH"))`
`2492`	`2501`	`/* Similar to the above, but don't complete "WITH" again. */`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc407d54

File tree

1 file changed

1 file changed

`‎src/bin/psql/tab-complete.in.c`

0 commit comments