Request a Demo
Home   >   mailing lists

Re: CREATE TABLE fails - Mailing list pgsql-general

From Ron Johnson
Subject Re: CREATE TABLE fails
Date
Msg-id CANzqJaAXyx9j5hxrY11acr7iPmzz9K9xQ83SfpPXnhUo3f1iAA@mail.gmail.com
Whole thread
In response to CREATE TABLE fails  (Igor Korot <ikorot01@gmail.com>)
Responses Re: CREATE TABLE fails
List pgsql-general
Tree view
On Sun, Mar 8, 2026 at 6:10 PM Igor Korot <ikorot01@gmail.com> 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.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: CREATE TABLE fails
Next
From: Ron Johnson
Date:
Subject: Re: CREATE TABLE fails