Commit202cbdf

committed

Add tab-completion for ALTER TABLE ALTER CONSTRAINT in psql.

Back-patch to 9.4 where ALTER TABLE ALTER CONSTRAINT was added.Michael Paquier, bug reported by Andrey Lizenko.

1 parentafeacd2 commit202cbdfCopy full SHA for 202cbdf

File tree

-4

lines changed

-4

lines changed

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1605,7 +1605,7 @@ psql_completion(const char *text, int start, int end)`
`1605`	`1605`	`elseif (pg_strcasecmp(prev4_wd,"ALTER")==0&&`
`1606`	`1606`	`pg_strcasecmp(prev3_wd,"TABLE")==0&&`
`1607`	`1607`	`pg_strcasecmp(prev_wd,"ALTER")==0)`
`1608`		`-COMPLETE_WITH_ATTR(prev2_wd," UNION SELECT 'COLUMN'");`
	`1608`	`+COMPLETE_WITH_ATTR(prev2_wd," UNION SELECT 'COLUMN' UNION SELECT 'CONSTRAINT'");`
`1609`	`1609`
`1610`	`1610`	`/* ALTER TABLE xxx RENAME */`
`1611`	`1611`	`elseif (pg_strcasecmp(prev4_wd,"ALTER")==0&&`
`@@ -1655,12 +1655,13 @@ psql_completion(const char *text, int start, int end)`
`1655`	`1655`	`COMPLETE_WITH_ATTR(prev3_wd,"");`
`1656`	`1656`
`1657`	`1657`	`/*`
`1658`		`- * If we have ALTER TABLE <sth> DROP\|RENAME\|VALIDATE CONSTRAINT, provide`
`1659`		`- * list of constraints`
	`1658`	`+ * If we have ALTER TABLE <sth>ALTER\|DROP\|RENAME\|VALIDATE CONSTRAINT,`
	`1659`	`+ *providelist of constraints`
`1660`	`1660`	`*/`
`1661`	`1661`	`elseif (pg_strcasecmp(prev5_wd,"ALTER")==0&&`
`1662`	`1662`	`pg_strcasecmp(prev4_wd,"TABLE")==0&&`
`1663`		`- (pg_strcasecmp(prev2_wd,"DROP")==0\|\|`
	`1663`	`+ (pg_strcasecmp(prev2_wd,"ALTER")==0\|\|`
	`1664`	`+pg_strcasecmp(prev2_wd,"DROP")==0\|\|`
`1664`	`1665`	`pg_strcasecmp(prev2_wd,"RENAME")==0\|\|`
`1665`	`1666`	`pg_strcasecmp(prev2_wd,"VALIDATE")==0)&&`
`1666`	`1667`	`pg_strcasecmp(prev_wd,"CONSTRAINT")==0)`

Comments

(0)