Hi,

Cascade and restrict options are supported for drop statistics syntax:
drop statistics stat1 cascade;
drop statistics stat2 restrict;

The documentation for this was missing, attached a patch which
includes the documentation for these options.

Regards,
Vignesh
From a7f1bf7eb8e1d693274016e937188987c2c9890c Mon Sep 17 00:00:00 2001
From: vignesh <vignesh21@gmail.com>
Date: Fri, 16 Jul 2021 18:21:54 +0530
Subject: [PATCH v1] Documented cascade and restrict option for drop
 statistics.

Cascade and restrict options were not documented for drop statistics.
Added the documentation for the cascade and restrict option.
---
 doc/src/sgml/ref/drop_statistics.sgml | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/drop_statistics.sgml b/doc/src/sgml/ref/drop_statistics.sgml
index f58c3d6d22..1532ca9584 100644
--- a/doc/src/sgml/ref/drop_statistics.sgml
+++ b/doc/src/sgml/ref/drop_statistics.sgml
@@ -21,7 +21,7 @@ PostgreSQL documentation
 
  <refsynopsisdiv>
 <synopsis>
-DROP STATISTICS [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ...]
+DROP STATISTICS [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
 </synopsis>
  </refsynopsisdiv>
 
@@ -59,6 +59,18 @@ DROP STATISTICS [ IF EXISTS ] <replaceable class="parameter">name</replaceable>
     </listitem>
    </varlistentry>
 
+   <varlistentry>
+    <term><literal>CASCADE</literal></term>
+    <term><literal>RESTRICT</literal></term>
+
+    <listitem>
+     <para>
+      These key words do not have any effect, since there are no dependencies
+      on statistics.
+     </para>
+    </listitem>
+   </varlistentry>
+
   </variablelist>
  </refsect1>
 
-- 
2.25.1

Reply via email to