Re: Fix error message when trying to alter statistics on includedcolumn

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Fix error message when trying to alter statistics on includedcolumn
Дата
Msg-id 20180712165358.j4qv43rcqekrj2h4@alap3.anarazel.de
обсуждение исходный текст
Ответ на Fix error message when trying to alter statistics on includedcolumn  (Yugo Nagata <nagata@sraoss.co.jp>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jerry Jelinek
Дата:
Сообщение: Re: patch to allow disable of WAL recycling
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: small doc fix - using expressions in plpgsql FETCH command