Commit1d15d0d

committed

psql: Tab-complete LOCK [TABLE] ... IN {ACCESS|ROW|SHARE}.

Suggest the lock modes that begin with the word in question.Thomas Munro, reviewed by Marllius Ribeiro. Comments tweaked by me.

1 parentc6ff380 commit1d15d0dCopy full SHA for 1d15d0d

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2662,6 +2662,17 @@ psql_completion(const char *text, int start, int end)`
`2662`	`2662`	`"SHARE ROW EXCLUSIVE MODE",`
`2663`	`2663`	`"EXCLUSIVE MODE","ACCESS EXCLUSIVE MODE");`
`2664`	`2664`
	`2665`	`+/* Complete LOCK [TABLE] <table> IN ACCESS\|ROW with rest of lock mode */`
	`2666`	`+elseif (Matches4("LOCK",MatchAny,"IN","ACCESS\|ROW")\|\|`
	`2667`	`+Matches5("LOCK","TABLE",MatchAny,"IN","ACCESS\|ROW"))`
	`2668`	`+COMPLETE_WITH_LIST2("EXCLUSIVE MODE","SHARE MODE");`
	`2669`	`+`
	`2670`	`+/* Complete LOCK [TABLE] <table> IN SHARE with rest of lock mode */`
	`2671`	`+elseif (Matches4("LOCK",MatchAny,"IN","SHARE")\|\|`
	`2672`	`+Matches5("LOCK","TABLE",MatchAny,"IN","SHARE"))`
	`2673`	`+COMPLETE_WITH_LIST3("MODE","ROW EXCLUSIVE MODE",`
	`2674`	`+"UPDATE EXCLUSIVE MODE");`
	`2675`	`+`
`2665`	`2676`	`/* NOTIFY --- can be inside EXPLAIN, RULE, etc */`
`2666`	`2677`	`elseif (TailMatches1("NOTIFY"))`
`2667`	`2678`	`COMPLETE_WITH_QUERY("SELECT pg_catalog.quote_ident(channel) FROM pg_catalog.pg_listening_channels() AS channel WHERE substring(pg_catalog.quote_ident(channel),1,%d)='%s'");`

Comments

(0)