i can't drop an idex - Mailing list pgsql-general

Hi everybody

 I trying to drop an index,

mhc2db=> \di antic
           List of relations
 Schema | Name  | Type  | Owner | Table
--------+-------+-------+-------+-------
 public | antic | index | pau   |
(1 row)



but when i try to fo it I get the following error

mhc2db=> drop index antic;

ERROR:  could not open relation with OID 596166

why when I do \di the table column is empty? i don't see this index in any table but when i try to create the index again i get

mhc2db=> create index antic on h_2_dbn (aa);
ERROR:  relation "antic" already exists

Some of you could tell me what is wrong?

thanks

pau

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat