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 |
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 |