On Thu, Jun 1, 2017 at 6:40 PM, Alexander Korotkov <a.korot...@postgrespro.ru> wrote: > On Wed, May 31, 2017 at 7:18 PM, Alexander Korotkov > <a.korot...@postgrespro.ru> wrote: >> >>> >>> Don't like either of those particularly, but what about just targeting >>> a column by column number, independently of whether it's an expression? >>> >>> ALTER INDEX myindex ALTER COLUMN 4 SET STATISTICS 1000; >> >> >> I completely agree with that. >> If no objections, I will write a patch for that. > > > Please, find it in attached patch. > > I decided to forbid referencing columns by numbers for tables, because those > numbers could contain gaps. Also, I forbid altering statistics target for > non-expression index columns, because it has no effect. >
In order to avoid losing track of this patch, I think it is better to add it in open items list for 10. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
