Hi everybody
I have a problem with index, i droped a table before drop their indexs, so, now i can't remove the index
at the momet i manage to rename the index, but their are so big and I wold like to remove them
I tried to do it as a root, but i keep having the following error
mhc2db=# drop index merda1;
ERROR: could not open relation with OID 596166
any idea?
thanks
--
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@xxxxxxxxxxxxxx
I have a problem with index, i droped a table before drop their indexs, so, now i can't remove the index
at the momet i manage to rename the index, but their are so big and I wold like to remove them
I tried to do it as a root, but i keep having the following error
mhc2db=# drop index merda1;
ERROR: could not open relation with OID 596166
any idea?
thanks
--
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@xxxxxxxxxxxxxx