Re: Fix error message when trying to alter statistics on included column

From: Andres Freund <andres(at)anarazel(dot)de>
To: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fix error message when trying to alter statistics on included column
Date: 2018-07-12 16:53:58
Message-ID: 20180712165358.j4qv43rcqekrj2h4@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2018-07-12 17:00:15 Re: small doc fix - using expressions in plpgsql FETCH command
Previous Message Jerry Jelinek 2018-07-12 16:49:22 Re: patch to allow disable of WAL recycling