i can't drop an idex

Поиск
Список
Период
Сортировка
От Pau Marc Munoz Torres
Тема i can't drop an idex
Дата
Msg-id 19b5841a0809160147h7d92b984p79d5e90dc08cb7a1@mail.gmail.com
обсуждение исходный текст
Ответы Re: i can't drop an idex  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: could not open file "pg_subtrans/0014": Invalid argument
Следующее
От: Joao Ferreira gmail
Дата:
Сообщение: Re: about partitioning