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