Re: creating index names automatically?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: creating index names automatically?
Дата
Msg-id 5047F34D-A165-4173-A51D-4A70D3012081@kineticode.com
обсуждение исходный текст
Ответ на Re: creating index names automatically?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: creating index names automatically?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
On Dec 22, 2009, at 7:31 PM, Tom Lane wrote:

> Wait a minute.  I must have been looking at the wrong keyword list
> --- ON already is reserved.  The problem is exactly that it can't
> tell whether CREATE INDEX CONCURRENTLY ON ... means to default the
> index name or to create an index named CONCURRENTLY.  So really the
> *only* way to fix this is to make CONCURRENTLY be at least
> type_func_name_keyword.

+1 if it prevents indexes from being named "CONCURRENTLY".

Best,

David


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: creating index names automatically?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: join ordering via Simulated Annealing