drop index

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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)