Re: Strange syntax for create/drop index

On Apr 9, 2006, at 12:56 , Haris Peco wrote:

> 'drop index' request schema prefix, but 'create index' doesn't
> accept schema prefix

Currently indexes must be in the same schema as the table they index,
so no schema is accepted for CREATE INDEX. Indeed, the documentation
for CREATE INDEX describes the name parameter so:

http://www.postgresql.org/docs/current/interactive/sql-
createindex.html#AEN42146

> name
>
> The name of the index to be created. No schema name can be
> included here; the index is always created in the same schema as
> its parent table.

However, you could have two or more indexes with the same name, but
in different schemas, so you need to be able to schema-qualify an
index when you drop it, so DROP INDEX accepts a schema-qualified name.

Hope this helps.

Michael Glaesemann
grzm myrealbox com