Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTa7G-0006sQ-7G for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 02:39:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTa7F-0005PZ-3R for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 02:39:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTa7E-0005PN-SV for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 02:39:36 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTa7B-0002fO-69 for pgsql-docs@postgresql.org; Thu, 01 Sep 2022 02:39:36 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1oTa79-007Ggm-DI; Wed, 31 Aug 2022 22:39:31 -0400 Date: Wed, 31 Aug 2022 22:39:31 -0400 From: Bruce Momjian To: Jeff Janes Cc: pgsql-docs Subject: Re: CREATE INDEX...USING Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Aug 18, 2022 at 12:32:28PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 11:21:58PM -0400, Bruce Momjian wrote: > > However, CREATE INDEX just lists the parameters, not the keywords, so it > > was already there as 'method', as you mentioned above. I will just > > remove the USING section I recently added. > > I wrote the attached patch to address the issues above. Patch applied back to PG 10. Thanks for the tip. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson