public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sahul Hameed <[email protected]>
To: Igor Korot <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: CREATE TABLE fails
Date: Sun, 8 Mar 2026 22:40:29 +0000
Message-ID: <CAGcyALQDJOJz6vK3nEpzSsTWpchcGQGV6i-3iiycNtq1WbcLPA@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>
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 );
--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.
>
>
>
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: <CAGcyALQDJOJz6vK3nEpzSsTWpchcGQGV6i-3iiycNtq1WbcLPA@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