Hello,
I have tried create/drop index in separate schema :
example :
create table :
create table test.test(id integer not null,name varchar(30),constraint
test_pkey primary key (id)) - ok
create index test_name on test.test(name) - ok
drop index test_name - not ok
drop index test.test_name - ok
create index test.test_name on test.test(name) - not ok
'drop index' request schema prefix, but 'create index' doesn't accept schema
prefix
this is strange for me
Comments ?
Best
Peco
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
