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

From: Chris Mair <chrisnospam(at)1006(dot)org>
To: Jorge Godoy <jgodoy(at)gmail(dot)com>
Cc: PostgreSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why isn't it allowed to create an index in a schema
Date: 2006-11-12 16:26:42
Message-ID: 20061112172642.38060a29.chrisnospam@1006.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pgsql-general@list.coretech.ro 2006-11-12 16:36:52 specify whitch index to use
Previous Message Martijn van Oosterhout 2006-11-12 16:15:49 Re: Why isn't it allowed to create an index in a schema other than public?