PATCH: Minor doc addition to CLUSTER page

Started by Andy Lesterover 15 years ago1 messages

andy@petdance.com

over 15 years ago

1 attachment(s)

I couldn't figure out how to get rid of the CLUSTER flag on an index.
Once I got the answer from IRC, I wrote this patch to point future users
to the answer.

xoxo,
Andy

--
Andy Lester => andy@petdance.com => www.petdance.com => AIM:petdance

Attachments:

cluster-docs.patchtext/plain; charset=us-asciiDownload

diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml
index 662de36..7afe72a 100644
--- a/doc/src/sgml/ref/cluster.sgml
+++ b/doc/src/sgml/ref/cluster.sgml
@@ -176,6 +176,15 @@ CREATE TABLE <replaceable class="parameter">newtable</replaceable> AS
     temporary file about the same size as the table itself, so peak disk usage
     is about three times the table size instead of twice the table size.
    </para>
+
+   <para>
+    To remove the internal flag that notes that an index has been clustered,
+    use <command>ALTER TABLE</command>.
+<programlisting>
+ALTER TABLE <replaceable class="parameter">table</replaceable> SET WITHOUT CLUSTER;
+</programlisting>
+   </para>
+
  </refsect1>
 
  <refsect1>