Re: creating index names automatically?

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: creating index names automatically?
Дата
Msg-id 4B2DEA0C.4020008@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на creating index names automatically?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut wrote:
> Could we create an option to create index names automatically, so you'd
> only have to write
> 
> CREATE INDEX ON foo (a);
> 
> which would pick a name like foo_a_idx.  

Why wouldn't it default to a name more like:
 CREATE INDEX "foo(a)" on foo(a);

which would extend pretty nicely to things like:
 CREATE INDEX "foo USING GIN(hstore)" ON foo USING GIN(hstore);'

Seems to be both more readable and less chance for arbitrary
collisions if I have column names with underscores.  Otherwise
what would the rule distinguishing "create index on foo(a_b)"
from "create index on foo(a,b)", etc.






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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: alpha3 bundled -- please verify
Следующее
От: James William Pye
Дата:
Сообщение: Re: alpha3 bundled -- please verify