i can't drop an idex
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
Pau Marc Munoz Torres wrote:
but when i try to fo it I get the following error
mhc2db=> drop index antic;
ERROR: could not open relation with OID 596166
You might want to provide some more details, like:
- Your operating system and version
- What version of PostgreSQL you are using
- If you're on Windows, whether you're using a virus scanner
or desktop search program
- Your disk configuration, particularly whether you have some form
of redundant storage (RAID, SAN, etc)
- Whether you've recently had any file system problems
- Whether you have ever directly altered anything in the PostgreSQL
data directories
--
Craig Ringer