Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 60ABD1D4D60F for ; Sun, 20 May 2012 23:13:34 -0300 (ADT) Received: from mail-ob0-f174.google.com ([209.85.214.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SWI7m-00041S-1E for pgsql-docs@postgresql.org; Mon, 21 May 2012 02:13:33 +0000 Received: by obbtb18 with SMTP id tb18so7441842obb.19 for ; Sun, 20 May 2012 19:13:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=BxhJUxekPyAsBxsxWLTkniS+QD6GeCNeOb78ZWwnJUs=; b=oU7X3PGhnrp19Z+oTqeyWjhGzGuH0A8pY5TTxGM+0gugjymA94cpI+ZjXIlyML4mRQ i+AyhY61JiXbLCutITSz4vsqgUYVfx3KhXyM294O2qKU3FxF7mBBoMr2NhJcko1mZJT3 OJ2H7a9BOU93a1o75qJHiiOaui6SeUr4PfmxQMsm7CQqHdMan1qu9/7NYpCrOuw58FQo sz1slwtlwieanMhYuMxc1B5ZinUzm4VAKtlOXaLHBxHbqxpaW5eeti4JlFcG5xa6azq1 B5WcrSznEjzxc2zycPepSvNY77hZ4cSnoMPl/nt+pwNh8O10IlvK4CGi+w6BurE8as+f aqKg== Received: by 10.60.171.80 with SMTP id as16mr17551094oec.59.1337566396991; Sun, 20 May 2012 19:13:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.60.146.180 with HTTP; Sun, 20 May 2012 19:12:56 -0700 (PDT) From: Josh Kupershmidt Date: Sun, 20 May 2012 19:12:56 -0700 Message-ID: Subject: ALTER TABLE ... CLUSTER ON synopsis To: pgsql-docs Content-Type: multipart/mixed; boundary=bcaec54c5270f4c8f204c0827167 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201205/21 X-Sequence-Number: 7346 --bcaec54c5270f4c8f204c0827167 Content-Type: text/plain; charset=ISO-8859-1 Hi all, The reference page for ALTER TABLE[1] correctly has the synopsis: CLUSTER ON index_name but later leaves off the "ON" keyword: CLUSTER I think the latter description should match the former, especially since 'ON' is mandatory; small patch attached. Josh [1] http://www.postgresql.org/docs/devel/static/sql-altertable.html --bcaec54c5270f4c8f204c0827167 Content-Type: application/octet-stream; name="alter_table_cluster_on.diff" Content-Disposition: attachment; filename="alter_table_cluster_on.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_h2gwbs470 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbCBiL2RvYy9zcmMv c2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbApuZXcgZmlsZSBtb2RlIDEwMDY0NAppbmRleCBhMzlj YjhmLi4wNGUzZTU0CioqKiBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbAotLS0g Yi9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwKKioqKioqKioqKioqKioqIEFMVEVS IFRBQkxFIFsgSUYgRVhJU1RTIF0gPHJlcGxhY2VhYmxlIGMKKioqIDM4NywzOTMgKioqKgogICAg IDwvdmFybGlzdGVudHJ5PgogIAogICAgIDx2YXJsaXN0ZW50cnk+CiEgICAgIDx0ZXJtPjxsaXRl cmFsPkNMVVNURVI8L2xpdGVyYWw+PC90ZXJtPgogICAgICA8bGlzdGl0ZW0+CiAgICAgICA8cGFy YT4KICAgICAgICBUaGlzIGZvcm0gc2VsZWN0cyB0aGUgZGVmYXVsdCBpbmRleCBmb3IgZnV0dXJl Ci0tLSAzODcsMzkzIC0tLS0KICAgICA8L3Zhcmxpc3RlbnRyeT4KICAKICAgICA8dmFybGlzdGVu dHJ5PgohICAgICA8dGVybT48bGl0ZXJhbD5DTFVTVEVSIE9OPC9saXRlcmFsPjwvdGVybT4KICAg ICAgPGxpc3RpdGVtPgogICAgICAgPHBhcmE+CiAgICAgICAgVGhpcyBmb3JtIHNlbGVjdHMgdGhl IGRlZmF1bHQgaW5kZXggZm9yIGZ1dHVyZQo= --bcaec54c5270f4c8f204c0827167--