Re: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS - Mailing list pgsql-hackers

From Yugo Nagata
Subject Re: Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS
Date
Msg-id 20180629164358.56aab015.nagata@sraoss.co.jp
Whole thread Raw
In response to Re: Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, 28 Jun 2018 10:26:13 -0400
Robert Haas <robertmhaas@gmail.com> wrote:

> On Wed, Jun 27, 2018 at 9:22 AM, Yugo Nagata <nagata@sraoss.co.jp> 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 <nagata@sraoss.co.jp>


pgsql-hackers by date:

Previous
From: Yugo Nagata
Date:
Subject: Re: CREATE TABLE .. LIKE .. EXCLUDING documentation
Next
From: Sergei Kornilov
Date:
Subject: Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query