| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: CREATE TABLE fails |
| Date: | 2026-03-08 23:37:26 |
| Message-ID: | CAKFQuwacfsmtWBGTs12nqNGC0fbagFX5gkPUCx0OMAL2-L9b3Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday, March 8, 2026, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> >>
> >> But the page at
> >> https://www.postgresql.org/docs/16/sql-createtable.html#
> SQL-CREATETABLE-STORAGE-PARAMETERS
> >> says it's available.
> >>
> >> What am I missing?
Those are table storage parameters.
> primary
> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
> autovacuum_enabled = on ));
> ERROR: unrecognized parameter "autovacuum_enabled"
> draft=#
>
You are specifying index storage parameters here.
The first paragraph of your linked section says:
“Storage parameters for indexes are documented in CREATE INDEX
<https://www.postgresql.org/docs/16/sql-createindex.html>.”
You will find autovacuum_enabled is not listed there. Because you can’t
vacuum an index separately from its table.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2026-03-08 23:38:59 | Re: CREATE TABLE fails |
| Previous Message | Igor Korot | 2026-03-08 23:32:55 | Re: CREATE TABLE fails |