Re: INDEX with optional storage parameter value

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Bruce Momjian <bruce(at)momjian(dot)us>, galiev_mr(at)taximaxim(dot)ru, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: INDEX with optional storage parameter value
Date: 2020-06-29 07:26:57
Message-ID: 218a622abfb0aa895e9fce4e41b278e469932211.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
0001-Document-that-values-can-be-omitted-for-boolean-stor.patch text/x-patch 7.9 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-06-29 13:53:17 Re: INDEX with optional storage parameter value
Previous Message Michael Paquier 2020-06-29 07:18:58 Re: INDEX with optional storage parameter value