Re: CREATE TABLE fails

Christoph,

On Sun, Mar 8, 2026 at 5:29 PM Christoph Moench-Tegeder
<cmt(at)burggraben(dot)net> wrote:
>
> ## Igor Korot (ikorot01(at)gmail(dot)com):
>
> > [quote]
> > draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
> > drafttype smallint, scoringtype smallint, roundvalues smallint,
> > leaguetype char(5), salary integer, benchplayers smallint, primary
> > key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
> > autovacuum_enabled ));
> > ERROR: unrecognized parameter "autovacuum_enabled"
> > [/quote]
> >
> > But the page at
> > https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
> > says it's available.
>
> It's available as a TABLE storage parameter, but you put it on the index
> definition (where it's not valid) - this could be a conceptual mistake
> or a misplaced right parenthesis.
> See the example on your linked page:
> https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS:~:text=fill%20factor%20for%20both%20the%20table%20and%20its%20unique%20index

Please check the PRIMARY KEY clause on that same linked page.
It says "Storage Parameters" are definitely supported there.

Thank you.

>
> Regards,
> Christoph
>
> --
> Spare Space