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