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)
Список
Дерево обсуждения
creating index names automatically? Peter Eisentraut <peter_e@gmx.net>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Michael Glaesemann <grzm@seespotcode.net>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Alvaro Herrera <alvherre@commandprompt.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? "David E. Wheeler" <david@kineticode.com>
Re: creating index names automatically? Alvaro Herrera <alvherre@commandprompt.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Greg Stark <gsstark@mit.edu>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Greg Stark <gsstark@mit.edu>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Greg Stark <gsstark@mit.edu>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Guillaume Smet <guillaume.smet@gmail.com>
Re: creating index names automatically? Robert Haas <robertmhaas@gmail.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Robert Haas <robertmhaas@gmail.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Robert Haas <robertmhaas@gmail.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Robert Haas <robertmhaas@gmail.com>
Re: creating index names automatically? Tom Lane <tgl@sss.pgh.pa.us>
Re: creating index names automatically? Robert Haas <robertmhaas@gmail.com>
Re: creating index names automatically? tomas@tuxteam.de
Re: creating index names automatically? "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: creating index names automatically? Brendan Jurd <direvus@gmail.com>
Re: creating index names automatically? Ron Mayer <rm_pg@cheapcomplexdevices.com> 
Alvaro Herrera  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
Дата:
Следующее
От: Heikki Linnakangas
Дата:
FAQ