Sahul, On Sun, Mar 8, 2026 at 5:40 PM Sahul Hameed <[email protected]> wrote: > > The problem is that you're putting the WITH clause on the PRIMARY KEY > constraint, which applies to the index, not the table. > > 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 = true );
This definitely is supported for the PRIMARY KEY constraint. Just remove the faulty clause and leave only "fillfactor" one... Thank you. > > --Sahul > > On Sun, Mar 8, 2026 at 10:10 PM Igor Korot <[email protected]> wrote: >> >> Hi, ALL, >> >> [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. >> >> What am I missing? >> >> Thank you. >> >>
