[PATCH] Tab completion for VACUUM of partitioned tables

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема [PATCH] Tab completion for VACUUM of partitioned tables
Дата
Msg-id 20200728170408.GI20393@telsasoft.com
обсуждение исходный текст
Ответы Re: [PATCH] Tab completion for VACUUM of partitioned tables  (Masahiko Sawada <masahiko.sawada@2ndquadrant.com>)
Список pgsql-hackers
Could maybe backpatch to v10.

diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index 272f799c24..06ef658afb 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -578,14 +578,23 @@ static const SchemaQuery Query_for_list_of_vacuumables = {
     .catname = "pg_catalog.pg_class c",
     .selcondition =
     "c.relkind IN (" CppAsString2(RELKIND_RELATION) ", "
+    CppAsString2(RELKIND_PARTITIONED_TABLE) ", "
     CppAsString2(RELKIND_MATVIEW) ")",
     .viscondition = "pg_catalog.pg_table_is_visible(c.oid)",
     .namespace = "c.relnamespace",
     .result = "pg_catalog.quote_ident(c.relname)",
 };
 
-/* Relations supporting CLUSTER are currently same as those supporting VACUUM */
-#define Query_for_list_of_clusterables Query_for_list_of_vacuumables
+/* Relations supporting CLUSTER */
+static const SchemaQuery Query_for_list_of_clusterables = {
+    .catname = "pg_catalog.pg_class c",
+    .selcondition =
+    "c.relkind IN (" CppAsString2(RELKIND_RELATION) ", "
+    CppAsString2(RELKIND_MATVIEW) ")",
+    .viscondition = "pg_catalog.pg_table_is_visible(c.oid)",
+    .namespace = "c.relnamespace",
+    .result = "pg_catalog.quote_ident(c.relname)",
+};
 
 static const SchemaQuery Query_for_list_of_constraints_with_schema = {
     .catname = "pg_catalog.pg_constraint c",

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [PATCH] Initial progress reporting for COPY command
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal