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 1w7yI1-0005QM-22 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 16:19:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7yI0-001Q7a-1E for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 16:19:32 +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 1w7yI0-001Q7S-0K for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 16:19:32 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7yHx-000000002fC-2q3K for pgsql-hackers@postgresql.org; Wed, 01 Apr 2026 16:19:32 +0000 Received: by mail-qv1-xf35.google.com with SMTP id 6a1803df08f44-8a23f802e0cso42513216d6.1 for ; Wed, 01 Apr 2026 09:19:29 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775060368; cv=none; d=google.com; s=arc-20240605; b=f4FBM2cBmEEsrMPxBDETLdDhej0cZyRgMgaz9q8RJ7FXkAEWIiCtXGtbEnwLTD8FS+ POZwYeXVo8kwZt1sL5Jr9uYyyX7+AMRUpNPNE9bzz4/AdKc4xe/O9ZEBw/Jslz6dDhD2 R8X3N0e/y/WYDMQnntXpKWFZtfE7oEQWP6oEagAVP9LrB/339h+UPlaLfxoSaV4Q1X1E Sz28lE2R+crR9LdKVJvl55OpZorqPbn1dvrWur/3h15vODodFU1LX4XHJc2taSiR1sla Rk2vogEOF0pSdLZGEkQdssDZwRrNTbuTlKI+AfHEPp/7ufiR5M29C2SpKuQqayIe5AlF vh+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:in-reply-to:references :mime-version:dkim-signature; bh=hhlK/FdiqPQawdqapXUrNEHZZnaDaCkUGeVrPv22+Ow=; fh=WSIFKH2ANZN9UxTETHNHi6YXVrb4vyahLeH2VVgHR9A=; b=amh2tezMxNHLMDuQpCg43ir3QtqVH5G8YVPmQ8xKAj5IKclv44A6FL1uZ/txu+ltMm Huo94825qIIM2QiRX3MtaQIdbO2aVPYK0kRta/um0v4RBrsQkC7oaNyT6R6gTp4xksah 4LYPm1IdWfoxXy8VEw1ECsycif3zlNu8/GuCyo0m0oVFGMcEO3WJijhqdREZtZVcQTU5 Oa2XP8spxdzflMklGB0/hrhGD/RfKJu8h3eglHtNu4VP+U8eXbTiDgDi7oK8EvxURmpY J4iW4k7RKxGtcyniN47frqt6QsjdhcxGMlmtddeMdV4tZQ0sKkgw2q6Z83lr9sC02nUC 03Kw==; darn=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=20251104; t=1775060368; x=1775665168; darn=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=hhlK/FdiqPQawdqapXUrNEHZZnaDaCkUGeVrPv22+Ow=; b=JR3sU+jMtisSm5VFtj5yiRvCap1crfyNrl0Ud7GVFR4paXifG6K7LvEEJNvqIiM7jU HRc0Bqn0UEzhivzLJOB8/7eDEYuSCJA2Rj8qri4ImecggxDeQMn02pVR6CflfH8SfoUJ 50hIJBx6064bVUlahjFk0M0LNd63LYGc23ERvo1dJRmMqAWh8Ls+rSkN9JmU4glhGvaM Jvxmo6RV4CXnM3j3Ss/b6rac+ADfkuhjFB2EZYHtV6X78spfUeeZw/FCVL1NvrHjWXRg RP1cMndKdhGJo44NvUG7Lt5QEusFn65Y2mQp/LaCSNOYvpXXwX+0TS0ihDRUfpD83gMh +WUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775060368; x=1775665168; 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=hhlK/FdiqPQawdqapXUrNEHZZnaDaCkUGeVrPv22+Ow=; b=Q2+KwsXUKjrQBMAjSL8eG7CTX3KHBjZWuePnB9CqYrvAvZCy4LF5dmRhqr2OJPwyu2 XJxBA+u4CfPVlPozl2dWzaaaXabvqzXOnCMEgiuM/VY2ptu8gGPhjcWR8lVdogyrI5Pe w9lPv6dkNBRDG/w07ccM9dMCWyw6J3Dp13kBcWvGv/RzV05j2wxZvkmp3n7mYL6jlOTF Z+/FUGzxRPsQEln1Xd14nIvkEGBrm+JbyYK+C6OUHtqEote3O6Rga71r96z9WVl2pQoo ZA0DTXZ4syFwD8uzZNtGAfXFXGVMNgNu0nmVM2N1C4NfZumN1RnueUqk7CYhmnIv+iFC lLHw== X-Forwarded-Encrypted: i=1; AJvYcCWsWz07iTO0Hzzi0PMNZ2CMXccjMR1UN/1DEmUtjTg1Wy+tXJTcaDhok+CDDfL9RK0xvSw/KtfjnsMCxH52@postgresql.org X-Gm-Message-State: AOJu0YwY5nNOsqalkJ7vf6iF5GlrBu/0PsB5iatAzUHjeceQGKV3Z284 av2reum+8kZ0qVmP0b3qkXryfRgMPzFsYJ39U7fDN70/NYPR2obLdEBL3h3OpQzs+1PQvZE25hs VM23e9YtG91Wi+wAt0Z1L9z6clh0AhmmJVKMh X-Gm-Gg: ATEYQzzxIsIvTTtthryKu0HYA9gXrtipVFs7Xr+vYc3itfAIcTpHIPLmgnadlsLOIlb Y6pR9/IlpLHjaGG4sxfJkim0ZFZ8SVxsGzu3Z+9Q4Z9T/sh73qYM4yo/mk9mm7jEDUYtCRB8Tnh sWtS7QAxScLIeUCJdMxs43THt6EUde7fgWNI/BrofoPYythReQHMxgP/8ZlDWyH19eNEFerF8f2 8QeYOgwhhkNV5uVdLIbJ1VHYOp2YQpgkZp0hLMloV/1ReIqgmRS1Yru5ULLn6tjmmT/3qdb9XWW ku6qJZHbk8dRf4kLdkZbIotZHtXdwbK1QU0egGsupw== X-Received: by 2002:a05:6214:c6e:b0:8a2:4fea:4d3f with SMTP id 6a1803df08f44-8a437f0f00fmr67002626d6.21.1775060367912; Wed, 01 Apr 2026 09:19:27 -0700 (PDT) MIME-Version: 1.0 References: <20260324203430.411331c59ca462457ec0aa8b@sraoss.co.jp> <20260325131548.4c9a0c8d05a422021b1ba76c@sraoss.co.jp> <20260327134637.957f51dafa2182a717a4cd78@sraoss.co.jp> <20260328150425.79219072e05f12e6b911b5e7@sraoss.co.jp> <20260331234745.80572b0c208cac1f13837011@sraoss.co.jp> In-Reply-To: <20260331234745.80572b0c208cac1f13837011@sraoss.co.jp> From: Dean Rasheed Date: Wed, 1 Apr 2026 17:19:16 +0100 X-Gm-Features: AQROBzAf9sNohjo5YLOgjSOahxfz-ouvHSXSGUQQj6lFse6NZoEtG7kxKfdwKmg Message-ID: Subject: Re: Adjust error message for CREATE STATISTICS to account for expressions To: Yugo Nagata Cc: John Naylor , Michael Paquier , Pgsql Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 31 Mar 2026 at 15:47, Yugo Nagata wrote: > > Yes, that sounds good to me. > > In particular, the following suggestion from Dean Rasheed seems like a > good approach: > > > Error: cannot create extended statistics on a single column > > Detail: Univariate statistics are already built for each individual > > table column I've pushed that change as part of the patch to support extended statistics on virtual generated columns [1], since I felt that patch already needed to change that error message. I didn't look more widely at other error messages in that file might benefit from having separate errdetail text. Regards, Dean [1] https://www.postgresql.org/message-id/flat/20250422181006.dd6f9d1d81299f5b2ad55e1a@sraoss.co.jp