Commit0b46e82

committed

Add tab completion for ALTER TABLE .. FORCE ROW LEVEL SECURITY in psql

This completes both the FORCE and NO FORCE options, NO INHERIT needing asmall adjustment.Author: Li JapinDiscussion:https://postgr.es/m/15B10F9F-5847-4F5E-BD66-8E25AA473C95@hotmail.com

1 parent321633e commit0b46e82Copy full SHA for 0b46e82

File tree

-2

lines changed

-2

lines changed

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1974,10 +1974,10 @@ psql_completion(const char *text, int start, int end)`
`1974`	`1974`	`*/`
`1975`	`1975`	`elseif (Matches("ALTER","TABLE",MatchAny))`
`1976`	`1976`	`COMPLETE_WITH("ADD","ALTER","CLUSTER ON","DISABLE","DROP",`
`1977`		`-"ENABLE","INHERIT","NO INHERIT","RENAME","RESET",`
	`1977`	`+"ENABLE","INHERIT","NO","RENAME","RESET",`
`1978`	`1978`	`"OWNER TO","SET","VALIDATE CONSTRAINT",`
`1979`	`1979`	`"REPLICA IDENTITY","ATTACH PARTITION",`
`1980`		`-"DETACH PARTITION");`
	`1980`	`+"DETACH PARTITION","FORCE ROW LEVEL SECURITY");`
`1981`	`1981`	`/* ALTER TABLE xxx ENABLE */`
`1982`	`1982`	`elseif (Matches("ALTER","TABLE",MatchAny,"ENABLE"))`
`1983`	`1983`	`COMPLETE_WITH("ALWAYS","REPLICA","ROW LEVEL SECURITY","RULE",`
`@@ -2007,6 +2007,9 @@ psql_completion(const char *text, int start, int end)`
`2007`	`2007`	`/* ALTER TABLE xxx INHERIT */`
`2008`	`2008`	`elseif (Matches("ALTER","TABLE",MatchAny,"INHERIT"))`
`2009`	`2009`	`COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables,"");`
	`2010`	`+/* ALTER TABLE xxx NO */`
	`2011`	`+elseif (Matches("ALTER","TABLE",MatchAny,"NO"))`
	`2012`	`+COMPLETE_WITH("FORCE ROW LEVEL SECURITY","INHERIT");`
`2010`	`2013`	`/* ALTER TABLE xxx NO INHERIT */`
`2011`	`2014`	`elseif (Matches("ALTER","TABLE",MatchAny,"NO","INHERIT"))`
`2012`	`2015`	`COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables,"");`

Comments

(0)