Re: Why isn't it allowed to create an index in a schema

Поиск
Список
Период
Сортировка
От Chris Mair
Тема Re: Why isn't it allowed to create an index in a schema
Дата
Msg-id 20061112172642.38060a29.chrisnospam@1006.org
обсуждение исходный текст
Ответ на Re: Why isn't it allowed to create an index in a schema other than public?  (Jorge Godoy <jgodoy@gmail.com>)
Список pgsql-general
> >     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.

Read what \di *.* shows: the index *is* inside schema testing.

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


Bye, Chris.


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Why isn't it allowed to create an index in a schema other than public?
Следующее
От: "pgsql-general@list.coretech.ro"
Дата:
Сообщение: specify whitch index to use