Re: CREATE TABLE fails

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-09T00:04:43Z
Lists: pgsql-general
On Sunday, March 8, 2026, Igor Korot <ikorot01@gmail.com> wrote:

> David,
>
> On Sun, Mar 8, 2026 at 6:49 PM David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> >
> > On Sunday, March 8, 2026, Igor Korot <ikorot01@gmail.com> wrote:
> >>
> >>
> >> So the "WITH " clause is definitely available for indexes.
> >
> >
> > Yeah, given you aren’t getting a syntax error all this advice to change
> the syntax is wrong.  Though assuming you meant to apply it to the table
> was at least reasonable given the lack of confirmed intent statement for
> what the command should be doing.
>
> Thanks.
> It is a little confusing how it is written in the docs.
>
> But I'm not sure how to explain it better. ;-)
>
>
Yeah, using the same term for two separate things isn’t ideal.  Using
table_storage_parameters and index_storage_parameters separately, and
directly pointing the later to the create index page, would probably be
better than an overlookable single sentence in the big storage parameters
paragraph.

David J.