public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: Igor Korot <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: CREATE TABLE fails
Date: Sun, 8 Mar 2026 18:29:52 -0400
Message-ID: <CANzqJaAXyx9j5hxrY11acr7iPmzz9K9xQ83SfpPXnhUo3f1iAA@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTyGEM-1mwxKPbwFTOodf+YUX=TxTmBPY5S=Yh1h=oVY9A@mail.gmail.com>
References: <CA+FnnTyGEM-1mwxKPbwFTOodf+YUX=TxTmBPY5S=Yh1h=oVY9A@mail.gmail.com>
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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: CREATE TABLE fails
In-Reply-To: <CANzqJaAXyx9j5hxrY11acr7iPmzz9K9xQ83SfpPXnhUo3f1iAA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox