diff options
| author | Bruce Momjian | 2004-08-20 04:29:33 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2004-08-20 04:29:33 +0000 |
| commit | 09d4e96d7e957ae34263650498b279452fe95265 (patch) | |
| tree | e4a06683989e5feef20c2848305799a18d1b4de5 /src/bin | |
| parent | daa076c4fdd32aff597eda4c34347d488c5b1e3a (diff) | |
Add ALTER INDEX, particularly for moving tablespaces.
Gavin Sherry
Diffstat (limited to 'src/bin')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 15 |
1 files changed, 13 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 130fcd33f4b..1b036be8427 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2003, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.109 2004/07/28 14:23:30 tgl Exp $ + * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.110 2004/08/20 04:29:32 momjian Exp $ */ /*---------------------------------------------------------------------- @@ -632,7 +632,8 @@ psql_completion(char *text, int start, int end) pg_strcasecmp(prev3_wd, "TABLE") != 0) { static const char *const list_ALTER[] = - {"DATABASE", "GROUP", "SCHEMA", "TABLE", "TRIGGER", "USER", NULL}; + {"DATABASE", "GROUP", "SCHEMA", "TABLE", "TRIGGER", "USER", "INDEX", + NULL}; COMPLETE_WITH_LIST(list_ALTER); } @@ -646,6 +647,16 @@ psql_completion(char *text, int start, int end) COMPLETE_WITH_LIST(list_ALTERDATABASE); } + /* ALTER INDEX <name> */ + else if (pg_strcasecmp(prev3_wd, "ALTER") == 0 && + pg_strcasecmp(prev2_wd, "INDEX") == 0) + { + static const char *const list_ALTERINDEX[] = + {"SET TABLESPACE", "OWNER TO", "RENAME TO", NULL}; + + COMPLETE_WITH_LIST(list_ALTERINDEX); + } + /* ALTER TRIGGER <name>, add ON */ else if (pg_strcasecmp(prev3_wd, "ALTER") == 0 && pg_strcasecmp(prev2_wd, "TRIGGER") == 0) |