Commit22b2dec

committed

Add CURRENT_ROLE to list of roles for tab completion of GRANT in psql

This compatibility has been added in45b9805, but psql forgot the call.Author: Wei WangReviewed-by: Aleksander AlekseevDiscussion:https://postgr.es/m/OS3PR01MB6275935F62E161BCD393D6559E489@OS3PR01MB6275.jpnprd01.prod.outlook.com

1 parent783be78 commit22b2decCopy full SHA for 22b2dec

File tree

-1

lines changed

-1

lines changed

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -764,6 +764,7 @@ static const SchemaQuery Query_for_list_of_collations = {`
`764`	`764`	`" FROM pg_catalog.pg_roles "\`
`765`	`765`	`" WHERE substring(pg_catalog.quote_ident(rolname),1,%d)='%s'"\`
`766`	`766`	`" UNION ALL SELECT 'PUBLIC'"\`
	`767`	`+" UNION ALL SELECT 'CURRENT_ROLE'"\`
`767`	`768`	`" UNION ALL SELECT 'CURRENT_USER'"\`
`768`	`769`	`" UNION ALL SELECT 'SESSION_USER'"`
`769`	`770`
`@@ -3450,7 +3451,7 @@ psql_completion(const char *text, int start, int end)`
`3450`	`3451`
`3451`	`3452`	`/*`
`3452`	`3453`	`* Complete "GRANT/REVOKE ... TO/FROM" with username, PUBLIC,`
`3453`		`- * CURRENT_USER, or SESSION_USER.`
	`3454`	`+ *CURRENT_ROLE,CURRENT_USER, or SESSION_USER.`
`3454`	`3455`	`*/`
`3455`	`3456`	`elseif ((HeadMatches("GRANT")&&TailMatches("TO"))\|\|`
`3456`	`3457`	`(HeadMatches("REVOKE")&&TailMatches("FROM")))`
`@@ -3884,6 +3885,7 @@ psql_completion(const char *text, int start, int end)`
`3884`	`3885`	`COMPLETE_WITH("FOR");`
`3885`	`3886`	`elseif (Matches("CREATE","USER","MAPPING","FOR"))`
`3886`	`3887`	`COMPLETE_WITH_QUERY(Query_for_list_of_roles`
	`3888`	`+" UNION SELECT 'CURRENT_ROLE'"`
`3887`	`3889`	`" UNION SELECT 'CURRENT_USER'"`
`3888`	`3890`	`" UNION SELECT 'PUBLIC'"`
`3889`	`3891`	`" UNION SELECT 'USER'");`

Comments

(0)