i can't drop an idex

From: "Pau Marc Munoz Torres" <paumarc(at)gmail(dot)com>
To: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: i can't drop an idex
Date: 2008-09-16 08:47:27
Message-ID: 19b5841a0809160147h7d92b984p79d5e90dc08cb7a1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)munoz(at)bioinf(dot)uab(dot)cat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joao Ferreira gmail 2008-09-16 10:11:12 Re: about partitioning
Previous Message Enrico Sabbadin 2008-09-16 08:39:35 Re: client_encoding / postgresql strange behaviour