diff options
| author | Fujii Masao <fujii@postgresql.org> | 2014-11-28 21:29:45 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2014-11-28 21:30:20 +0900 |
| commit | 19b1511a48f2ebdce94fe5f85a89dd6c36da1ba5 (patch) | |
| tree | 782642bd0fffb733d04c265de652c562b1665d28 | |
| parent | 0ec68a083b0619eaf48f7249a6659216c9fe5e35 (diff) | |
| download | postgresql-19b1511a48f2ebdce94fe5f85a89dd6c36da1ba5.tar.gz postgresql-19b1511a48f2ebdce94fe5f85a89dd6c36da1ba5.zip | |
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.
| -rw-r--r-- | src/bin/psql/tab-complete.c | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index afb5e9962e0..6126f7407ae 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -1483,7 +1483,7 @@ psql_completion(const char *text, int start, int end) else if (pg_strcasecmp(prev4_wd, "ALTER") == 0 && pg_strcasecmp(prev3_wd, "TABLE") == 0 && pg_strcasecmp(prev_wd, "ALTER") == 0) - COMPLETE_WITH_ATTR(prev2_wd, " UNION SELECT 'COLUMN'"); + COMPLETE_WITH_ATTR(prev2_wd, " UNION SELECT 'COLUMN' UNION SELECT 'CONSTRAINT'"); /* ALTER TABLE xxx RENAME */ else if (pg_strcasecmp(prev4_wd, "ALTER") == 0 && @@ -1533,12 +1533,13 @@ psql_completion(const char *text, int start, int end) COMPLETE_WITH_ATTR(prev3_wd, ""); /* - * If we have ALTER TABLE <sth> DROP|RENAME|VALIDATE CONSTRAINT, provide - * list of constraints + * If we have ALTER TABLE <sth> ALTER|DROP|RENAME|VALIDATE CONSTRAINT, + * provide list of constraints */ else if (pg_strcasecmp(prev5_wd, "ALTER") == 0 && pg_strcasecmp(prev4_wd, "TABLE") == 0 && - (pg_strcasecmp(prev2_wd, "DROP") == 0 || + (pg_strcasecmp(prev2_wd, "ALTER") == 0 || + pg_strcasecmp(prev2_wd, "DROP") == 0 || pg_strcasecmp(prev2_wd, "RENAME") == 0 || pg_strcasecmp(prev2_wd, "VALIDATE") == 0) && pg_strcasecmp(prev_wd, "CONSTRAINT") == 0) |