Christoph, On Sun, Mar 8, 2026 at 5:29 PM Christoph Moench-Tegeder <[email protected]> wrote: > > ## Igor Korot ([email protected]): > > > [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
