Ron, On Sun, Mar 8, 2026 at 5:30 PM Ron Johnson <[email protected]> wrote: > > On Sun, Mar 8, 2026 at 6: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? > > > Probably "= on", since this does work: > ALTER TABLE foo SET (autovacuum_enabled = off); > ALTER TABLE foo SET (autovacuum_enabled = on); > > This raises the question "why are you explicitly enabling autovacuum_enabled > in the CREATE TABLE statement?", since autovavuum should be globally enabled.
Still the same: [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 = on )); ERROR: unrecognized parameter "autovacuum_enabled" draft=# [/quote] Thank you, > > -- > Death to <Redacted>, and butter sauce. > Don't boil me, I'm still alive. > <Redacted> lobster!
