| From: | "Pau Marc Munoz Torres" <paumarc(at)gmail(dot)com> |
|---|---|
| To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | drop index |
| Date: | 2008-09-16 12:48:23 |
| Message-ID: | 19b5841a0809160548saf8153bsf9d486b092406366@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)munoz(at)bioinf(dot)uab(dot)cat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reg Me Please | 2008-09-16 12:59:09 | Re: Index order |
| Previous Message | Bill Moran | 2008-09-16 12:40:45 | Re: Obfuscated stored procedures (was Re: Oracle and Postgresql) |