Re: Why isn't it allowed to create an index in a schema other than public?

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Why isn't it allowed to create an index in a schema other than public?
Дата
Msg-id 87d57sekuh.fsf@ieee.org
обсуждение исходный текст
Ответ на Re: Why isn't it allowed to create an index in a schema  (Chris Mair <chrisnospam@1006.org>)
Ответы Re: Why isn't it allowed to create an index in a schema other than public?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Why isn't it allowed to create an index in a schema  (Chris Mair <chrisnospam@1006.org>)
Список pgsql-general
Chris Mair <chrisnospam@1006.org> writes:

> Just say
>     create index testing123_index on testing.testing123 (otherthing);
> and you'll otain exactly what you want (see below).
>
> Bye, Chris.

I know I can workaround such debilitation.  What I wanted to know is if
there's some reason (such as performance gain, for example) for that
decision.

Using this approach, though, doesn't group all items that belong to a schema
inside of it.

--
Jorge Godoy      <jgodoy@gmail.com>


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Linux vs. FreeBSD
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Why isn't it allowed to create an index in a schema other than public?