Michael,
You have name A for 'create index' and name B for 'drop index'
I can think that it isn't same index
This is illogically for me
make object with name A and drop it with name B
> If the schema was allowed, some people would infer that they
> can place the index in a schema other tha
On Apr 9, 2006, at 13:33 , Haris Peco wrote:
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
Allowing a schema-qualifie
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
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 des
