i can't drop an idex

Started by Pau Marc Munoz Torresover 17 years ago2 messagesgeneral
Jump to latest
#1Pau Marc Munoz Torres
paumarc@gmail.com

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

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Pau Marc Munoz Torres (#1)
Re: i can't drop an idex

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