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 1w5CzR-0030g5-1U for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 01:24:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5CzO-00A8H7-1t for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 01:24:55 +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 1w5CzO-00A8Gy-0u for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2026 01:24:54 +0000 Received: from mail-qt1-x844.google.com ([2607:f8b0:4864:20::844]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5CzN-00000000soq-01nf for pgsql-hackers@postgresql.org; Wed, 25 Mar 2026 01:24:53 +0000 Received: by mail-qt1-x844.google.com with SMTP id d75a77b69052e-5091d71aa11so5476461cf.1 for ; Tue, 24 Mar 2026 18:24:52 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774401892; cv=none; d=google.com; s=arc-20240605; b=TdE8CsG2eGcbCHGKenoSSvaaDg8QujvuDL13h+hs76s31yOJ7cSscYAfXLWyFxym1a lIYrIZJIuDj37ou7zdsOJYbYmJEXAPdY1GLQdHGKIyzMT343bGCUbBcjuMeJa6ykIedQ /u5XjJpo2sz+IWclZ3zs6txsXezNZ9dH4ytl8JdQrYHXVYlG/j3UwFmKX9Q6v5irLss7 MpezdnXxtIdwC1AWn8DhZZSycYynOR/uRSMntCNYW0yBxnTUW11MVRLxaFPR79x/DKi7 Px8+BMylh5VvcIhT2GJA5fHcBjCaellxTAMW/dS2v8yaIp54ZW5Zmvdc8cD9k/DZG6Ch aRIg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=wgcb2jz8MSeUohvzps6pfz7jnfrErwwf13dGlNjnrCM=; fh=wG2O5chZ56JwlKs5fklU8DQUUSn850XLtBx+Fp5dUQ8=; b=BOvykcV02F44O1xcxBKf2bDs5aly6nQwB8VrIq3dCvKSpsaCJXqtxGj6y/PMdYGe5G +2ZNPECgpPULyEmVWumufXO+jKCnq3rcguqsQJFeO1Ego6AuKQV8VaT01znpn6pBD50w yhq4SSgQXCPPMMOpuNpknUTTXSztAXvLplg90Xb195kgxNAvmghe582FQUl2ih94a9XF Sn+Rp3YhtZFZBZELQ1X4zvWMt5XJHb+wQkKul2QftAQsQwkadb0666Ca0Ex07EGM79n1 bV1UkuWWzcU27CqepikR/ZUk6iZgn29bK0Ju+SQJk4I5ThNwWGnllPzUVT91gg4GaOE4 PTyg==; 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=1774401892; x=1775006692; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=wgcb2jz8MSeUohvzps6pfz7jnfrErwwf13dGlNjnrCM=; b=IYUH3luYk1B5p7G+YYwktb0Uj5TFSoDY9RCh3TSsoGLOwHRtkvj7qQaGYZPa+1h6ix lLQ8Wz/d+aYJTCObwrwEAp0kQoptby8YpMYte50o97qUwhadtlDP9UoeVQCzebLJAAPS ExlmqO71J8i9uLi2z4S6p0TWdJkI6xg1DE9/wbxZWr7eJ+X9M8+mA3DCxKExqXUa6Qj5 3g007AtIR7ijfje+7oTtCOuSlX4ZjcUy9IwHImfeDusqytbgwL0vVxTZVr97TR+sqXVg mJcLCgJaYlsZwKz5Umf61Ldb6uEpflubHeiXQs5NnYPNgjKGXxgwOtgXtwo6kf6MgT54 ZrNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774401892; x=1775006692; h=content-transfer-encoding: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=wgcb2jz8MSeUohvzps6pfz7jnfrErwwf13dGlNjnrCM=; b=AympoJjcUh45wb9BFn3ZWA92AjgbKlNPv508BJ/Q7GQ1IjPlmztMLAoxV+dqW5Xpoq 5Y/j8v++tjI9ZOYB12K/jNrmS/TFrOF0Bwuy3wYCNU8SE64IqWXH3DQC6YOngLn68I8m tZC+56DL/V8HqMdbk+i1ADwKG3GyjCguvSfxD0k/Kdf7N6A6nrXBo2ygoZLvy3rkwQo7 hPZtUIIvBywFLT+VKYplgWi8q98RWHSGBHsm3R9+p0jT1oqwfPrvleainVb+tKDD7OXf gSo3DbZZ0qOEF4s4N243WsfmviqueYBw9gOc/0rAqEL9yZqktjlvBhPs5HI6TJ2sw+ni q4fA== X-Gm-Message-State: AOJu0YytBhs1+Qb9jyVSKKsRe5u4i7Wko9/vlV7zaNakJ6BuYAWcsrHJ taOa8M4WSekfgOWj4kNqZ7FzylMdPxhGqRLLZOEUU8w6rrjV93l+lTEootO0S2BG/n2l2QI2LC2 VAGybnHtXkVYOcb4PGLqQT+cpxISbw3PLKqzAR3k= X-Gm-Gg: ATEYQzw61FAgF6gN9gGvFdgHzvuhcs5F0542gU6zDPuf0mVecrBuoV+iSXIAzuH1B3f h2uJh8gWJubJJD6Ff6hwQBbP5fKydBUeFY+AJUvSAVbDvjI/OdJXi01fp/vsyi+sdyEgeOpxUma rxCxOYk/OXQmTU3d+2JWYqqg0Vy1AERzpNw43KMGj0VSbb+ymE/ZsqCdfiuAm3tssE1NJywWi7S MBjQlGR4SMug//f+RSiajvy8bVfB5ATKoW/mCNMgbHhxR3eZCxNTAVvhuhPJP3DxQ64qyAOrE7b QBCklbbxrwE8fpaHCa5ElNGgqmFSjzDTwsXnsTNr0MVTC0IEM42pLAm3Xdd+Jpr9FiyDFXibMDw 7eooAUXMtE6GLHbEd5TqYsY0P8YWmBvrNwP0K9A== X-Received: by 2002:a05:622a:199f:b0:50b:3faf:9c60 with SMTP id d75a77b69052e-50b81d1ee04mr20332231cf.31.1774401892157; Tue, 24 Mar 2026 18:24:52 -0700 (PDT) MIME-Version: 1.0 References: <20260324203430.411331c59ca462457ec0aa8b@sraoss.co.jp> In-Reply-To: <20260324203430.411331c59ca462457ec0aa8b@sraoss.co.jp> From: John Naylor Date: Wed, 25 Mar 2026 08:24:40 +0700 X-Gm-Features: AaiRm53h4zsdFuJhyPCdFG-eJ9k4QhgOnp0Xiu_vroM4DT5pZfYoH46OmJ2yHoE Message-ID: Subject: Re: Adjust error message for CREATE STATISTICS to account for expressions To: Yugo Nagata Cc: Pgsql Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Mar 24, 2026 at 6:34=E2=80=AFPM Yugo Nagata w= rote: > > Hi, > > I've attached a patch to adjust the error message for CREATE STATISTICS > to account for expressions. > > Previously, when attempting to create extended statistics on a single col= umn, > the following error is raised. > > ERROR: extended statistics require at least 2 columns > > However, this message assumed only columns. In reality, an expression on = a > single column is also allowed, so two columns are not necessarily require= d. > Thgis patch updates the message to: > > ERROR: extended statistics require at least 2 columns or an expression I'm ambivalent about this. Instead of trying to document all the possible valid possibilities (which may get out of date again), maybe we can say that it's not allowed on a single column? -- John Naylor Amazon Web Services