public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: 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:22:12 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+FnnTx_RkQRiE5P3UiMD-uFANoZrOkfsx_Fznv_y47SHf3fHw@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>
	<CA+FnnTx_RkQRiE5P3UiMD-uFANoZrOkfsx_Fznv_y47SHf3fHw@mail.gmail.com>

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
[email protected]






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], [email protected]
  Subject: Re: CREATE TABLE fails
  In-Reply-To: <[email protected]>

* 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