Re: CREATE TABLE fails

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE TABLE fails
Date: 2026-03-09 00:04:43
Message-ID: CAKFQuwaqNVRP7HENn++zJEDkjE6RX9bFef+x15i9Frqo7DwiRA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, March 8, 2026, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> David,
>
> On Sun, Mar 8, 2026 at 6:49 PM David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> >
> > On Sunday, March 8, 2026, Igor Korot <ikorot01(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-09 01:08:43 Re: CREATE TABLE fails
Previous Message Igor Korot 2026-03-08 23:58:10 Re: CREATE TABLE fails