Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit879d713

Browse files
committed
Various fixes to REFRESH MATERIALIZED VIEW tab completion.
Masahiko Sawada, Fujii Masao, Kevin Grittner
1 parentad2e233 commit879d713

File tree

1 file changed

+7
-4
lines changed

1 file changed

+7
-4
lines changed

‎src/bin/psql/tab-complete.c

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -899,7 +899,7 @@ static const pgsql_thing_t words_after_create[] = {
899899
{"GROUP",Query_for_list_of_roles},
900900
{"LANGUAGE",Query_for_list_of_languages},
901901
{"INDEX",NULL,&Query_for_list_of_indexes},
902-
{"MATERIALIZED VIEW",NULL,NULL},
902+
{"MATERIALIZED VIEW",NULL,&Query_for_list_of_matviews},
903903
{"OPERATOR",NULL,NULL},/* Querying for this is probably not such a
904904
* good idea. */
905905
{"OWNED",NULL,NULL,THING_NO_CREATE},/* for DROP OWNED BY ... */
@@ -1264,7 +1264,8 @@ psql_completion(const char *text, int start, int end)
12641264
"DELETE FROM","DISCARD","DO","DROP","END","EXECUTE","EXPLAIN",
12651265
"FETCH","GRANT","IMPORT","INSERT","LISTEN","LOAD","LOCK",
12661266
"MOVE","NOTIFY","PREPARE",
1267-
"REASSIGN","REFRESH","REINDEX","RELEASE","RESET","REVOKE","ROLLBACK",
1267+
"REASSIGN","REFRESH MATERIALIZED VIEW","REINDEX","RELEASE",
1268+
"RESET","REVOKE","ROLLBACK",
12681269
"SAVEPOINT","SECURITY LABEL","SELECT","SET","SHOW","START",
12691270
"TABLE","TRUNCATE","UNLISTEN","UPDATE","VACUUM","VALUES","WITH",
12701271
NULL
@@ -2653,13 +2654,15 @@ psql_completion(const char *text, int start, int end)
26532654
elseif (Matches4("REFRESH","MATERIALIZED","VIEW",MatchAny))
26542655
COMPLETE_WITH_CONST("WITH");
26552656
elseif (Matches5("REFRESH","MATERIALIZED","VIEW","CONCURRENTLY",MatchAny))
2656-
COMPLETE_WITH_CONST("WITH DATA");
2657+
COMPLETE_WITH_CONST("WITH");
26572658
elseif (Matches5("REFRESH","MATERIALIZED","VIEW",MatchAny,"WITH"))
26582659
COMPLETE_WITH_LIST2("NO DATA","DATA");
26592660
elseif (Matches6("REFRESH","MATERIALIZED","VIEW","CONCURRENTLY",MatchAny,"WITH"))
2660-
COMPLETE_WITH_CONST("DATA");
2661+
COMPLETE_WITH_LIST2("NO DATA","DATA");
26612662
elseif (Matches6("REFRESH","MATERIALIZED","VIEW",MatchAny,"WITH","NO"))
26622663
COMPLETE_WITH_CONST("DATA");
2664+
elseif (Matches7("REFRESH","MATERIALIZED","VIEW","CONCURRENTLY",MatchAny,"WITH","NO"))
2665+
COMPLETE_WITH_CONST("DATA");
26632666

26642667
/* REINDEX */
26652668
elseif (Matches1("REINDEX"))

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp