| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(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 01:22:12 |
| Message-ID: | 1681187c-5b16-4801-9d4d-704fb71cc168@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2026-03-09 03:48:26 | Re: Emitting JSON to file using COPY TO |
| Previous Message | David G. Johnston | 2026-03-09 01:13:50 | Re: CREATE TABLE fails |