Re: [COMMITTERS] pgsql: Give a better error for duplicate entries inVACUUM/ANALYZE colu

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [COMMITTERS] pgsql: Give a better error for duplicate entries inVACUUM/ANALYZE colu
Дата
Msg-id 862733d5-f132-a59b-7afb-86002f946f80@2ndquadrant.com
обсуждение исходный текст
Ответ на [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZEcolu  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
On 9/21/17 18:13, Tom Lane wrote:
> Give a better error for duplicate entries in VACUUM/ANALYZE column list.
> 
> Previously, the code didn't think about this case and would just try to
> analyze such a column twice.

In the error message, we should write "specified more than once" instead
of "specified twice", because that could otherwise look a bit silly:

VACUUM ANALYZE vaccluster(i,i,i);
ERROR:  column "i" of relation "vaccluster" is specified twice

(Also, the "is" doesn't seem to fit there.)

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: [COMMITTERS] pgsql: Make construct_[md_]array return a valid empty array forzero-si
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu