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




---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to