Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzP7D-000yL3-2T for pgsql-general@arkaria.postgresql.org; Mon, 09 Mar 2026 01:08:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzP7B-00Cqmo-33 for pgsql-general@arkaria.postgresql.org; Mon, 09 Mar 2026 01:08:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzP7B-00Cqmf-1v for pgsql-general@lists.postgresql.org; Mon, 09 Mar 2026 01:08:58 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vzP79-00000001iNC-26dz for pgsql-general@lists.postgresql.org; Mon, 09 Mar 2026 01:08:57 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-7986c7b8076so118472417b3.2 for ; Sun, 08 Mar 2026 18:08:55 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773018534; cv=none; d=google.com; s=arc-20240605; b=TowWrbHo6rz4NBCqqNIqwfOcwCqrWGWdWcya1t/yeSBO9Ol6ASNDyCt+xh/nIYM94O Rcp2JinGrRnx7IGN4Pnc3SoOF0W3o5X4pgJ3fxomziqXUE0gdtCVuHofjrs1AQWbjNxk IDlpQUvIyPWBsc8soKeIBC6sAgkbXgwvDIkUuCf8bD6iiyTfZ8A3Wl3M96FgMuKyFMSZ Lo7oTPAd9NocUwga5nq3bXJsRrva3TF2hiBjytxsa0UdBLCmS2Rlxhg3afUBZv7E7QFN bjzh4+G6wuk217UUSOGm6oQkJXE6K38VSCeVmJ4uTc1TeNj97RZkOABFPB8ebC9vZUg+ lWFA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=o8d1V++TXyAf+BJijAISfRGaR0w7tQdTop00uZ/OhV8=; fh=kyAsYl77KsxRDd0MpChrI1Mi1G/EXxKHRVc31UaZmY8=; b=PKNcfOZ7+QOeBi0r3sXZePx/7h9lo5yg3j2t85lUsUth8oKwF5zUe4l2rMgAZywTcG PEmcyQoecaKKHyLO5bo2PZP4ZZ6eSj8mqv3D0p3nLXJU4Cmuh+x2S+74U0Ur6dLBpHsl CkjJ+G2BWFX2FZwcjjxMDyYL/E3Od8/O28ib/SXGOMcO82QVlFCoQ1DP4r/7NWtmMcSx zAO/f+BJc5D3n46t+pE8/dA3xIJf3Jz32/67g+nK2TJGZilQsAZLNwhgOnsPDPmkimYo Awv4Weq9PZVNVPqiStbRJNSHoy1klH26rpYQEmkL9rX+PogaD0cmJK454aaK5CnCnUW9 CCOQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773018534; x=1773623334; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=o8d1V++TXyAf+BJijAISfRGaR0w7tQdTop00uZ/OhV8=; b=EJH6TOoK5MqF8dHVQ2C5NU92x9Zs0JcQJmsA1GCPPFhyjWqAzuUETDgNqdl+1ue8sB 7lEWiySZ+U3Qd+v3NdMTK6r7tfmJA24ukjRcZm+3gU8szmbwqzRl9nNYXIMx/Q3mcHXu ZPIumnBUjgmJzAZPV+Dq4z6FT8PFFsqCEwEbLg1+l2HMlgbRREDrDQ/FDEifRHA2S8yZ GqtuoDtht3xICkvE/QSPKdFwBDk3wBQ8mXHegqNzT98tRKhMt1iYJQZ5BE3vyGKO/9VC YSM8STD39nlwAM8xlGOyQGvTzKAINxDKqcUAtenOV0rIZHnKwFieGBiMZoJIPJLbG5H8 ck8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773018534; x=1773623334; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=o8d1V++TXyAf+BJijAISfRGaR0w7tQdTop00uZ/OhV8=; b=Qufdh3ug/n3k0BTOgYO55ITZEHVLRDTzY2d9rvetRJD829wXx4E5V97nFHNZQCYuEd 7Q20rv+F4RvZeAw2oEayrnrkeErbH+X+JvpwvGsJ6yEGgpaZ/iy3nrnf9O6TeqegxmGL U0ROeE4E0YAP33gV67vXutDJffQOKT6haVJ+KIJZilZ/MOWsjTDcXrimr+8ZThMXamTO i4Yqi6IO1pFdvun1wudIl9PCLUf4A7M3b3eifRf2n24lFaCok16+gKchDq6FqoisBN+f RlXYnHPW58njok5yGPdLA9+ygP2b62zUDV4Vphn5JD66jee5MkemMfQ23VLlK8/cuDuv KTZQ== X-Gm-Message-State: AOJu0YzXkq9akvW+gBcqIFDhSqfZDmc/60/SOFPoFEGR4FVf+oPng4R/ WSwaF5xCeyBsl8CVn3KBKlCkuQc0KDvK2B/CySvar+sM/3/Iev9okkCliuqlklVHpHfIf4O8Roi Tf9P5L2hYm5Gk8+v1u903tbQxPnqDIg0tHQ== X-Gm-Gg: ATEYQzzBZHq954CYroFYpcEbT6nMtoeCjNpNEZvpWFqpSblxlJ03sQA2lXCs8as7B6Z qVunUQxCyOzI4jxovkDDDvKE4b0PpiLM2QQBsqfdZAOElYD2hVfO3DiUUu2zAtz7UzWyAseg5Ri VYFVE6FARkAqJjKTk9LahMp7q5yN1QIhQkza+KKrsB/zd97Dh2y4iDiv0iGOwO7gIBGCaNhAsDm UttHhHwy/dnvVR7YuK8PgR9sUIl8cbDxdXqXHYUI/LEp9zEYSV+HXP4OEZpRvLA9HF0+HsGrKOb iV4= X-Received: by 2002:a05:690c:4d47:b0:798:980f:6756 with SMTP id 00721157ae682-798dd7c381fmr97473497b3.54.1773018533699; Sun, 08 Mar 2026 18:08:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Igor Korot Date: Sun, 8 Mar 2026 18:08:43 -0700 X-Gm-Features: AaiRm51B9avzXf-v3W0bGMD9wx9txLmMFV1uJ2n82Jn-6qH_dRsnd8MXQ12xGlA Message-ID: Subject: Re: CREATE TABLE fails To: "David G. Johnston" Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000e1a635064c8d0b13" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e1a635064c8d0b13 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable David, On Sun, Mar 8, 2026 at 5:04=E2=80=AFPM David G. Johnston wrote: > On Sunday, March 8, 2026, Igor Korot wrote: > >> David, >> >> On Sun, Mar 8, 2026 at 6:49=E2=80=AFPM David G. Johnston >> wrote: >> > >> > On Sunday, March 8, 2026, Igor Korot wrote: >> >> >> >> >> >> So the "WITH " clause is definitely available for indexes. >> > >> > >> > Yeah, given you aren=E2=80=99t getting a syntax error all this advice = to change >> the syntax is wrong. Though assuming you meant to apply it to the table >> was at least reasonable given the lack of confirmed intent statement for >> what the command should be doing. >> >> Thanks. >> It is a little confusing how it is written in the docs. >> >> But I'm not sure how to explain it better. ;-) >> >> > Yeah, using the same term for two separate things isn=E2=80=99t ideal. U= sing > table_storage_parameters and index_storage_parameters separately, and > directly pointing the later to the create index page, would probably be > better than an overlookable single sentence in the big storage parameters > paragraph. > I am not sure. But looking at the docs I point to it=E2=80=99s confusing. It doesn=E2=80=99t say that they are documented in CREATE INDEX. Maybe just add something like: =E2=80=9CThose storage parameters are for table only. If you need ones for = index - check CREATE INDEX page.=E2=80=9D Maybe put that where the WITH clause is explained. This emphasizes the difference between them. What do you think? Thank you. > David J. > > --000000000000e1a635064c8d0b13 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
David,

On Sun, Mar 8, 2026 at 5:04=E2=80=AFPM David G. Johnston <david.g.johnston@gmail.com> wrote:=
On Sunday, March 8, 2026, Igor Kor= ot <ikorot01@gma= il.com> wrote:
David,

On Sun, Mar 8, 2026 at 6:49=E2=80=AFPM David G. Johnston
<david.g= .johnston@gmail.com> wrote:
>
> On Sunday, March 8, 2026, Igor Korot <ikorot01@gmail.com> wrote:
>>
>>
>> So the "WITH " clause is definitely available for indexe= s.
>
>
> Yeah, given you aren=E2=80=99t getting a syntax error all this advice = to change the syntax is wrong.=C2=A0 Though assuming you meant to apply it = to the table was at least reasonable given the lack of confirmed intent sta= tement for what the command should be doing.

Thanks.
It is a little confusing how it is written in the docs.

But I'm not sure how to explain it better. ;-)


Yeah, using the same term for two separate= things isn=E2=80=99t ideal.=C2=A0 Using table_storage_parameters and index= _storage_parameters separately, and directly pointing the later to the crea= te index page, would probably be better than an overlookable single sentenc= e in the big storage parameters paragraph.

I am not sure. But looking at the docs I po= int to it=E2=80=99s confusing.

It doesn=E2=80=99t say that they are documented in CREATE INDEX.

Maybe just add something li= ke:

=E2=80=9CThose stora= ge parameters are for table only. If you need ones for index - check CREATE= INDEX page.=E2=80=9D

Ma= ybe put that where the WITH clause is explained.
This emphasizes the difference between them.
=

What do you think?

Thank you.
=

<= /div>
David J.

--000000000000e1a635064c8d0b13--