Postgres Pro
Downloads
Home   >   mailing lists

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

From Yugo Nagata
Subject Forbid referencing columns by names in ALTER INDEX ... SETSTATISTICS
Date
Msg-id 20180627222229.7425f272.nagata@sraoss.co.jp
Whole thread Raw
Responses Re: Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS
List pgsql-hackers
Tree view 
Hi,

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.

[1] https://www.postgresql.org/message-id/CAPpHfdsSYo6xpt0F%3DngAdqMPFJJhC7zApde9h1qwkdpHpwFisA%40mail.gmail.com

-- 
Yugo Nagata <nagata@sraoss.co.jp>
Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join
Next
From: Jonathan Lemig
Date:
Subject: Re: Name of main process differs between servers (postmaster vs postgres)