From d99d58cdc8c0b5b50ee92995e8575c100b1a458a Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Sat, 13 May 2017 01:05:48 -0300 Subject: Complete tab completion for DROP STATISTICS Tab-completing DROP STATISTICS would only work if you started writing the schema name containing the statistics object, because the visibility clause was missing. To add it, we need to add SQL-callable support for testing visibility of a statistics object, like all other object types already have. Discussion: https://postgr.es/m/22676.1494557205@sss.pgh.pa.us --- doc/src/sgml/func.sgml | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5f47c59f8ad..d55656769b2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -16680,6 +16680,12 @@ SELECT relname FROM pg_class WHERE pg_table_is_visible(oid); boolean is operator family visible in search path + + pg_statistic_ext_is_visible(stat_oid) + + boolean + is statistics object visible in search path + pg_table_is_visible(table_oid) @@ -16738,6 +16744,9 @@ SELECT relname FROM pg_class WHERE pg_table_is_visible(oid); pg_opfamily_is_visible + + pg_statistic_ext_is_visible + pg_table_is_visible -- cgit v1.2.3