Thread: i can't drop an idex

i can't drop an idex

From

"Pau Marc Munoz Torres"

Date:

16 September 2008, 08:47:39

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

Re: i can't drop an idex

From

Craig Ringer

Date:

22 September 2008, 04:12:05

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