drop index - Mailing list pgsql-general

From Pau Marc Munoz Torres
Subject drop index
Date
Msg-id 19b5841a0809160548saf8153bsf9d486b092406366@mail.gmail.com
Whole thread Raw
Responses Re: drop index  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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@bioinf.uab.cat

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Next
From: Reg Me Please
Date:
Subject: Re: Index order