psql: tab-complete ALTER ... DETACH CONCURRENTLY / FINALIZE

alvherre · alvherre · commit 6dd1042eda0a · 2021-04-26T16:14:10.000-04:00
New keywords per 71f4c8c. Discussion: https://postgr.es/m/20210422204035.GA25929@alvherre.pgsql
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
@@ -2209,6 +2209,8 @@ psql_completion(const char *text, int start, int end)
 		completion_info_charp = prev3_wd;
 		COMPLETE_WITH_QUERY(Query_for_partition_of_table);
 	}
+	else if (Matches("ALTER", "TABLE", MatchAny, "DETACH", "PARTITION", MatchAny))
+		COMPLETE_WITH("CONCURRENTLY", "FINALIZE");
 
 	/* ALTER TABLESPACE <foo> with RENAME TO, OWNER TO, SET, RESET */
 	else if (Matches("ALTER", "TABLESPACE", MatchAny))

Original file line number	Diff line number	Diff line change
`@@ -2209,6 +2209,8 @@ psql_completion(const char *text, int start, int end)`
`2209`	`2209`	`completion_info_charp = prev3_wd;`
`2210`	`2210`	`COMPLETE_WITH_QUERY(Query_for_partition_of_table);`
`2211`	`2211`	`}`
	`2212`	`+ else if (Matches("ALTER", "TABLE", MatchAny, "DETACH", "PARTITION", MatchAny))`
	`2213`	`+ COMPLETE_WITH("CONCURRENTLY", "FINALIZE");`
`2212`	`2214`
`2213`	`2215`	`/* ALTER TABLESPACE <foo> with RENAME TO, OWNER TO, SET, RESET */`
`2214`	`2216`	`else if (Matches("ALTER", "TABLESPACE", MatchAny))`