Re: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS

Поиск
Список
Период
Сортировка
Искать
От
Yugo Nagata
Тема
Re: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS
Дата
Msg-id
20180629164358.56aab015.nagata@sraoss.co.jp
Ответ на
Список
Дерево обсуждения
Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS Yugo Nagata <nagata@sraoss.co.jp>
Re: Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS Robert Haas <robertmhaas@gmail.com>
Re: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS Yugo Nagata <nagata@sraoss.co.jp>
On Thu, 28 Jun 2018 10:26:13 -0400
Robert Haas  wrote:

> On Wed, Jun 27, 2018 at 9:22 AM, Yugo Nagata  wrote:
> > According to the syntax in ALTER INDEX doc, a column should be specified by
> > column number as discussed in [1]. However, the current code still allows to
> > use an internal column name like "expr". Is this intentional?
> >
> > Although it is harmless, how about forbiding this undocumented and
> > unuseful behavior. The attached patch does it.
> 
> If it's harmless, why prohibit it?

I thought that we should prohibit it because this is not allowed
according to the documented syntax. However, don't we have to be
so rigorous about it?

> 
> -- 
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
> 


-- 
Yugo Nagata 

В списке pgsql-hackers по дате отправления
От: Yugo Nagata
Дата:
От: Sergei Kornilov
Дата:
FAQ