Re: CREATE TABLE fails

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>

To: Igor Korot <ikorot01@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>

Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>

Date: 2026-03-09T01:22:12Z

Lists: pgsql-general

On 3/8/26 6:08 PM, Igor Korot wrote:
> David,
> 

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

I thought it already did:

https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS

"Storage Parameters

The WITH clause can specify storage parameters for tables, and for 
indexes associated with a UNIQUE, PRIMARY KEY, or EXCLUDE constraint. 
Storage parameters for indexes are documented in CREATE INDEX. The 
storage parameters currently available for tables are listed below. ..."

> 
> Maybe put that where the WITH clause is explained.
> 
> This emphasizes the difference between them.
> 
> What do you think?
> 
> Thank you.
> 
> 
>     David J.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com