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
