diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2014-08-22 14:27:00 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2014-08-22 14:27:00 -0400 |
| commit | f41872d0c1239d36ab03393c39ec0b70e9ee2a3c (patch) | |
| tree | 4c07e9f8a6b0a3d4c9d1e19ca5595c39e5f6e43a /src/bin/psql/tab-complete.c | |
| parent | 01d15a2677c738489e62295924298ef8a72528a8 (diff) | |
Implement ALTER TABLE .. SET LOGGED / UNLOGGED
This enables changing permanent (logged) tables to unlogged and
vice-versa.
(Docs for ALTER TABLE / SET TABLESPACE got shuffled in an order that
hopefully makes more sense than the original.)
Author: Fabrízio de Royes Mello
Reviewed by: Christoph Berg, Andres Freund, Thom Brown
Some tweaking by Álvaro Herrera
Diffstat (limited to 'src/bin/psql/tab-complete.c')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index b4f185620f3..76b2b04c1ac 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -1641,12 +1641,12 @@ psql_completion(const char *text, int start, int end) completion_info_charp = prev3_wd; COMPLETE_WITH_QUERY(Query_for_index_of_table); } - /* If we have TABLE <sth> SET, provide WITHOUT,TABLESPACE and SCHEMA */ + /* If we have TABLE <sth> SET, provide list of attributes and '(' */ else if (pg_strcasecmp(prev3_wd, "TABLE") == 0 && pg_strcasecmp(prev_wd, "SET") == 0) { static const char *const list_TABLESET[] = - {"(", "WITHOUT", "TABLESPACE", "SCHEMA", NULL}; + {"(", "LOGGED", "SCHEMA", "TABLESPACE", "UNLOGGED", "WITH", "WITHOUT", NULL}; COMPLETE_WITH_LIST(list_TABLESET); } |