Commit19b1511

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 parent0ec68a0 commit19b1511Copy full SHA for 19b1511

File tree

-4

lines changed

-4

lines changed

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1483,7 +1483,7 @@ psql_completion(const char *text, int start, int end)`
`1483`	`1483`	`elseif (pg_strcasecmp(prev4_wd,"ALTER")==0&&`
`1484`	`1484`	`pg_strcasecmp(prev3_wd,"TABLE")==0&&`
`1485`	`1485`	`pg_strcasecmp(prev_wd,"ALTER")==0)`
`1486`		`-COMPLETE_WITH_ATTR(prev2_wd," UNION SELECT 'COLUMN'");`
	`1486`	`+COMPLETE_WITH_ATTR(prev2_wd," UNION SELECT 'COLUMN' UNION SELECT 'CONSTRAINT'");`
`1487`	`1487`
`1488`	`1488`	`/* ALTER TABLE xxx RENAME */`
`1489`	`1489`	`elseif (pg_strcasecmp(prev4_wd,"ALTER")==0&&`
`@@ -1533,12 +1533,13 @@ psql_completion(const char *text, int start, int end)`
`1533`	`1533`	`COMPLETE_WITH_ATTR(prev3_wd,"");`
`1534`	`1534`
`1535`	`1535`	`/*`
`1536`		`- * If we have ALTER TABLE <sth> DROP\|RENAME\|VALIDATE CONSTRAINT, provide`
`1537`		`- * list of constraints`
	`1536`	`+ * If we have ALTER TABLE <sth>ALTER\|DROP\|RENAME\|VALIDATE CONSTRAINT,`
	`1537`	`+ *providelist of constraints`
`1538`	`1538`	`*/`
`1539`	`1539`	`elseif (pg_strcasecmp(prev5_wd,"ALTER")==0&&`
`1540`	`1540`	`pg_strcasecmp(prev4_wd,"TABLE")==0&&`
`1541`		`- (pg_strcasecmp(prev2_wd,"DROP")==0\|\|`
	`1541`	`+ (pg_strcasecmp(prev2_wd,"ALTER")==0\|\|`
	`1542`	`+pg_strcasecmp(prev2_wd,"DROP")==0\|\|`
`1542`	`1543`	`pg_strcasecmp(prev2_wd,"RENAME")==0\|\|`
`1543`	`1544`	`pg_strcasecmp(prev2_wd,"VALIDATE")==0)&&`
`1544`	`1545`	`pg_strcasecmp(prev_wd,"CONSTRAINT")==0)`

Comments

(0)