public inbox for [email protected]  

help / color / mirror / Atom feed

From: Igor Korot <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: CREATE TABLE fails
Date: Sun, 8 Mar 2026 18:08:43 -0700
Message-ID: <CA+FnnTx_RkQRiE5P3UiMD-uFANoZrOkfsx_Fznv_y47SHf3fHw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwaqNVRP7HENn++zJEDkjE6RX9bFef+x15i9Frqo7DwiRA@mail.gmail.com>
References: <CA+FnnTyGEM-1mwxKPbwFTOodf+YUX=TxTmBPY5S=Yh1h=oVY9A@mail.gmail.com>
	<CAGcyALQDJOJz6vK3nEpzSsTWpchcGQGV6i-3iiycNtq1WbcLPA@mail.gmail.com>
	<CA+FnnTy2HFHwbXNXb_CZ_W+frsYbBvbr0+6syR2Ybgj4MqL1SA@mail.gmail.com>
	<CA+FnnTysPCFsd4DKkw8OBRDisS93Tg=tuH0ouj0r446Fz9MQSQ@mail.gmail.com>
	<CAKFQuwZa5uZSf8d-qc5KviXAbXzs3v34px=hjRpMmWR0igT+qg@mail.gmail.com>
	<CA+FnnTwB47fYN93B2C3QmCH0N0xfoUPEvrE7iFjYyCDG7p1UwQ@mail.gmail.com>
	<CAKFQuwaqNVRP7HENn++zJEDkjE6RX9bFef+x15i9Frqo7DwiRA@mail.gmail.com>

David,

On Sun, Mar 8, 2026 at 5:04 PM David G. Johnston <[email protected]>
wrote:

> On Sunday, March 8, 2026, Igor Korot <[email protected]> wrote:
>
>> David,
>>
>> On Sun, Mar 8, 2026 at 6:49 PM David G. Johnston
>> <[email protected]> wrote:
>> >
>> > On Sunday, March 8, 2026, Igor Korot <[email protected]> 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.
>

I am not sure. But looking at the docs I point to it’s confusing.

It doesn’t say that they are documented in CREATE INDEX.

Maybe just add something like:

“Those storage parameters are for table only. If you need ones for index -
check CREATE INDEX page.”

Maybe put that where the WITH clause is explained.

This emphasizes the difference between them.

What do you think?

Thank you.


> David J.
>
>

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: CREATE TABLE fails
  In-Reply-To: <CA+FnnTx_RkQRiE5P3UiMD-uFANoZrOkfsx_Fznv_y47SHf3fHw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox