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 1vzNs7-000xEM-0H for pgsql-general@arkaria.postgresql.org; Sun, 08 Mar 2026 23:49:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzNs5-00CQ0k-16 for pgsql-general@arkaria.postgresql.org; Sun, 08 Mar 2026 23:49:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzNs5-00CQ0c-05 for pgsql-general@lists.postgresql.org; Sun, 08 Mar 2026 23:49:17 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vzNs3-00000001COF-3GoU for pgsql-general@lists.postgresql.org; Sun, 08 Mar 2026 23:49:16 +0000 Received: by mail-oi1-x22f.google.com with SMTP id 5614622812f47-466f00535cfso873480b6e.1 for ; Sun, 08 Mar 2026 16:49:15 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773013755; cv=none; d=google.com; s=arc-20240605; b=UKkBcYxrDqpPyeFbZ3+WyQGGR2RIbG8gLnQiJ1YmDbC3tb0e//HHL1Vs51/tlGcoGC OCT6WZm7uqDE2BO+AG41njmgy45q40wzOGSVCoTvSEP1aj86W7gJMeh7jl6mS6Jdj8t/ NX5lfS/XBVJK5Cvaz8ZhbeTYWC5z3LmMVa6H6MKRyKCLr4k+TU38b3y3zKDf26LUReNt isZp4r4E9wsi6R0pgVqqiRrLWVS+CCcnYAfnYmRw8pAQgv42ndIZdFn9PhPGMhNDdazk zXCbpzn3WguJ3tRx+kj+Aau7hnM0GsoleLiQy3yB+KrOM4w9X55jZRBI0D67/TCIW9xf 4t+w== 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:references:in-reply-to :mime-version:dkim-signature; bh=WzsiL9fehbaGj58cxyQKqTF7xXK7zxxeoU0B+CYueeA=; fh=MqX3/PjeIRWyveucHIwmT3MEzIvphFWgoM5FEnVDTkI=; b=lWiGkt3J6fDicfUwzMJS9X+BAB/wfNNl/k0qMjhynk+3CZvQvp9kIvzl6QrAD0FZDg cSJcS/R5AGKpmiNix+TLmcLE0S8HFN/ISmHsbHo36Q5hAGNfPIqTM9/OGXI+SnqH4vq/ Whk0sv8C4jDNf/JCSTuRY5/Bs/mxGVr28D6SZvcrmbNORNYTf/SYjeGJdVtTNvGF/UGi jGmr6qPRXfcYKfVTN9DjULQ0ejozCu86Omv54SP2MqP60ATieAWa3jb/F0Nf+eIOn1Uv t8i84pIAl1V9aCWFT1F3vKU+dAgxkuv/TdqnFjvFlKiwnmJ6Oe/IAPn+zi8dTX+yyyYj rVpw==; 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=1773013755; x=1773618555; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=WzsiL9fehbaGj58cxyQKqTF7xXK7zxxeoU0B+CYueeA=; b=edwKbUgyVMtO6L/umTHxv9Fj9bmB2SargO0/0/cm+Xo8SWqsXd9hLVLvb56DpFpPvM K7sS4r1VDOwebmNfpwJzOu7s08D9gG2FJ8a66Dhj/KYleOI/8f5JBCn/edLumfJx+X17 c/uLG7RBJ+bNQTgRNlQLm/vMBgsVBCLFDlaE5p6gbwsGK3SQzsOc/+yW3hraugyeI+VR tX2Y6Z0UuZrzl0wwWrVhDlYxKo4TbUKfwOrM2vG9G86Tp6I2zMEKeid28HTUw2TAmPBR 3yVu7U1lKk1HC0AESyZld0fo6ALaUlTTIg7QlnRiXH02NkA9Nljoq6xUAVUVCV0WGRU3 Rvig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773013755; x=1773618555; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=WzsiL9fehbaGj58cxyQKqTF7xXK7zxxeoU0B+CYueeA=; b=Emx8gAp8uSuqmTY7uIbuO/tHJWxSHALcsYv12idnq+ExCYmlSzPJrBfLz+QGXyJ/hC dHY4WU6eDZsGywEnNiGQmkeE6ZF8Lw3KNOunpUCpQAuDpWQmoMyFzdxRb3hFgVTa9zP7 BHjBY0g3KZjvRCrqlBr0tZzVTaXB/5Ydn9133xjayh6nGtctchD98SgCZnJ33HB4zgYj 7yvS7Mm6ov7HgC+LKDf4jijpye/mME/3geWBUMuGOWK6fGRTNgns72ZV6gZTy/8aFSok 6hIgNoAg9LVpv4TX0Z3AMx8e+jhUWq3pKWJ1MOltUg29JaBksEQxVgEVlpWlAutPCRn0 wnKg== X-Gm-Message-State: AOJu0YyTaVCkF9vTGU9UoBk75/j4udV31wKnk6K4tM0cvHNKzr/V9g1S r1QYqtf7866yx6Qmj+XUW0dJYc8QM16+RxkF+syx45nCPrkk3LKx6hY00ZkXb25I1RELghe6HEy dZWq0WajqV4SiBUESnft8KtY+ShUChAU= X-Gm-Gg: ATEYQzyI9KGePWqZe7ojpbmHti3lBVf78NXLoZC9lm9mcjqs6EsOcjXPZuX+R91A+SR JvopcLMuBPvy3m0JLzQCQLv4vL4+6rIF0JOYlLpG1UgtZH/9hLgBVlgPS5DgvJlOeahAJ1IYXWA GGcJV13D7R05K9kKiP1D2QFb73hVnlJwVKZnlXLaWHuoDazoax2Z0n6e2tXT9/7dP7hmbkAB1kJ THWv0zpWGRX6vpAJtlFL+5h97eccEWRrAhyfhS9VlVZhZzCm2p/KM5/EDxWz1QHqUGoj6f/yQ0m C7hCCD4= X-Received: by 2002:a05:6808:1590:b0:45c:8c9a:44dd with SMTP id 5614622812f47-466dcb1aa30mr4799610b6e.39.1773013755174; Sun, 08 Mar 2026 16:49:15 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:1b41:0:b0:622:3933:832f with HTTP; Sun, 8 Mar 2026 16:49:14 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sun, 8 Mar 2026 16:49:14 -0700 X-Gm-Features: AaiRm52bWrCDxYIEbe6wKzMd-k1yK5T1Mf2G0dj93MjIzfBMITabKlYQZsv6EXI Message-ID: Subject: CREATE TABLE fails To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000f250c064c8bef2f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000f250c064c8bef2f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 ch= ange 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. David J. --0000000000000f250c064c8bef2f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sunday, March 8, 2026, Igor Korot <ikorot01@gmail.com> wrote:

So the "WITH " clause is definitely available for indexes.

Yeah, given you aren=E2=80=99t getting a s= yntax error all this advice to change the syntax is wrong.=C2=A0 Though ass= uming 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.

David J.

--0000000000000f250c064c8bef2f--