Re: CREATE TABLE fails

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "Ray O'Donnell" <ray(at)rodonnell(dot)ie>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE TABLE fails
Date: 2026-03-08 23:18:28
Message-ID: CA+FnnTye4ainfzjvPJJvNpeG0qHLTi9bo+3vaPWF2gQqypmQSA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ray,

On Sun, Mar 8, 2026 at 5:26 PM Ray O'Donnell <ray(at)rodonnell(dot)ie> wrote:

> Probably a silly question, but are you actually using version 16?
>

Yes, I am.

Thank you.

>
> Apologies for top-post.... phone app.
>
> Ray.
>
> On 8 March 2026 22:10:31 Igor Korot <ikorot01(at)gmail(dot)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?
>>
>> Thank you.
>>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-08 23:28:34 Re: CREATE TABLE fails
Previous Message Sahul Hameed 2026-03-08 22:40:29 Re: CREATE TABLE fails