MIME-Version: 1.0
References: <CA+FnnTyGEM-1mwxKPbwFTOodf+YUX=TxTmBPY5S=Yh1h=oVY9A@mail.gmail.com>
In-Reply-To: <CA+FnnTyGEM-1mwxKPbwFTOodf+YUX=TxTmBPY5S=Yh1h=oVY9A@mail.gmail.com>
From: Sahul Hameed <mail2shameed@gmail.com>
Date: Sun, 8 Mar 2026 22:40:29 +0000
Message-ID: <CAGcyALQDJOJz6vK3nEpzSsTWpchcGQGV6i-3iiycNtq1WbcLPA@mail.gmail.com>
Subject: Re: CREATE TABLE fails
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d0c657064c8af965"
Archived-At: <https://www.postgresql.org/message-id/CAGcyALQDJOJz6vK3nEpzSsTWpchcGQGV6i-3iiycNtq1WbcLPA%40mail.gmail.com>
Precedence: bulk

--000000000000d0c657064c8af965
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 =3D 50,
autovacuum_enabled =3D true );

--Sahul

On Sun, Mar 8, 2026 at 10:10=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wro=
te:

> Hi, ALL,
>
> [quote]
> draft=3D# 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 =3D 50,
> autovacuum_enabled ));
> ERROR:  unrecognized parameter "autovacuum_enabled"
> [/quote]
>
> But the page at
>
> https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-S=
TORAGE-PARAMETERS
> says it's available.
>
> What am I missing?
>
> Thank you.
>
>
>

--000000000000d0c657064c8af965
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The problem is that you&#39;re putting the WITH clause on =
the PRIMARY KEY constraint, which applies to the index, not the table.=C2=
=A0<br><div><br></div><div>CREATE TABLE leagues_new(id serial, name varchar=
(100),<br>=C2=A0 =C2=A0 drafttype smallint,scoringtype smallint,roundvalues=
 smallint,<br>=C2=A0 =C2=A0 leaguetype char(5),salary integer,benchplayers =
smallint,primary=C2=A0</div><div>key(id) INCLUDE (drafttype, scoringtype)<s=
pan style=3D"background-color:rgb(255,0,0)">) </span>WITH( fillfactor =3D 5=
0, autovacuum_enabled =3D true );<br></div><div><br></div><div>--Sahul=C2=
=A0</div></div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">On Sun, Mar 8, 2026 at 10:10=E2=80=AFPM Igor=
 Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi, ALL,=
<br>
<br>
[quote]<br>
draft=3D# CREATE TABLE leagues_new(id serial, name varchar(100),<br>
drafttype smallint, scoringtype smallint, roundvalues smallint,<br>
leaguetype char(5), salary integer, benchplayers smallint, primary<br>
key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor =3D 50,<br>
autovacuum_enabled ));<br>
ERROR:=C2=A0 unrecognized parameter &quot;autovacuum_enabled&quot;<br>
[/quote]<br>
<br>
But the page at<br>
<a href=3D"https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREA=
TETABLE-STORAGE-PARAMETERS" rel=3D"noreferrer" target=3D"_blank">https://ww=
w.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAM=
ETERS</a><br>
says it&#39;s available.<br>
<br>
What am I missing?<br>
<br>
Thank you.<br>
<br>
<br>
</blockquote></div>

--000000000000d0c657064c8af965--