Re: Why isn't it allowed to create an index in a schema - Mailing list pgsql-general

From Chris Mair
Subject Re: Why isn't it allowed to create an index in a schema
Date
Msg-id 20061112172642.38060a29.chrisnospam@1006.org
Whole thread Raw
In response to Re: Why isn't it allowed to create an index in a schema other than public?  (Jorge Godoy <jgodoy@gmail.com>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Why isn't it allowed to create an index in a schema other than public?
Next
From: "pgsql-general@list.coretech.ro"
Date:
Subject: specify whitch index to use