Re: INDEX with optional storage parameter value - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: INDEX with optional storage parameter value
Date
Msg-id 218a622abfb0aa895e9fce4e41b278e469932211.camel@cybertec.at
Whole thread Raw
In response to Re: INDEX with optional storage parameter value  (Bruce Momjian <bruce@momjian.us>)
Responses Re: INDEX with optional storage parameter value
List pgsql-docs
On Sat, 2020-06-27 at 17:14 -0400, Bruce Momjian wrote:
> > I noticed an slight inaccuracy in the documentation for CREATE INDEX and
> > ALTER INDEX:
> > 
> > CREATE INDEX ... [ WITH ( storage_parameter = value [, ... ] ) ]
> > ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter = value [, ... ] )
> > 
> > In indices, as in tables, you can omit the вoolean value for a parameter.
> > For example:
> > 
> > CREATE INDEX ON public.testtable USING GIN (c1) WITH (fastupdate);
> > ALTER INDEX testtable_c1_idx SET (fastupdate);
> > 
> > It might be more correct to use the construct from CREATE TABLE: 
> > 
> > storage_parameter [= value] [, ... ]
> 
> I found a few more places that also didn't properly document this; 
> patch attached.

Looks good.
Perhaps it is worth explaining this explicitly, as in the attached.

Yours,
Laurenz Albe

Attachment

pgsql-docs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: INDEX with optional storage parameter value
Next
From: Bruce Momjian
Date:
Subject: Re: INDEX with optional storage parameter value