Re: creating index names automatically?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: creating index names automatically?
Дата
Msg-id 4081.1261540475@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: creating index names automatically?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: creating index names automatically?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> David E. Wheeler wrote:
>> +1 if it prevents indexes from being named "CONCURRENTLY".

> Yeah, if you really want to have an index named like that you can use
> double quotes.  Seems a sensible compromise.

Well, this will also break tables and columns named "concurrently".
I think the odds of it being a problem are small, but still it is
a reserved word that shouldn't be reserved according to the SQL spec.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: creating index names automatically?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Tuplestore should remember the memory context it's created in