Re: Fix error message when trying to alter statistics on included column
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Yugo Nagata <nagata@sraoss.co.jp>, Teodor Sigaev <teodor@sigaev.ru>, Alexander Korotkov <aekorotkov@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2018-07-12T16:53:58Z
Lists: pgsql-hackers
Hi Alexander, Teodor, On 2018-06-28 18:28:03 +0900, Yugo Nagata wrote: > According to the error message, it is not allowed to alter statistics on > included column because this is "non-expression column". > > postgres=# create table test (i int, d int); > CREATE TABLE > postgres=# create index idx on test(i) include (d); > CREATE INDEX > postgres=# alter index idx alter column 2 set statistics 10; > ERROR: cannot alter statistics on non-expression column "d" of index "idx" > HINT: Alter statistics on table column instead. Is either of you going to take care of this one? IIRC Teodor committed the underlying patch, and Alexander wrote parts of it? Greetings, Andres Freund
Commits
-
Fix ALTER TABLE...SET STATS error message for included columns
- cb9db2ab0674 12.0 landed
- 802b04cb3fad 11.0 landed