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
|
Список | 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
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 по дате отправления: