Re: Strange syntax for create/drop index

Michael,

Thank you for answer, but you don't understand me
I understood syntax and reason for this, but why postgreSQL doesn't accept this :

create index test.test_name on test.test(name)

schema prefix in 'create index'

I know that it isn't necessary, because postgreSQL know that index is (must be)
in table's schema, but this is natural for sql writers

I expect that 'create ...' and 'drop ...' allow/request/don't accept schema prefix on same way

Thanks
Peco

On Sunday 09 April 2006 02:08 am, Michael Glaesemann wrote:
>
> 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
>
>
>