Postgres Pro
Downloads
Home   >   mailing lists

Thread: drop index

drop index

From
"Pau Marc Munoz Torres"
Date:
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

Re: drop index

From
Richard Huxton
Date:
Pau Marc Munoz Torres wrote:
> Hi everybody
>
>  I have a problem with index, i droped a table before drop their indexs, so,
> now i can't remove the index

That shouldn't be possible. What version of PostgreSQL is this?

--
  Richard Huxton
  Archonet Ltd

Re: drop index

From
"Pau Marc Munoz Torres"
Date:
 psql 8.2.6 (server 8.2.5)
 Schema |  Name  | Type  | Owner |    Table
--------+--------+-------+-------+--------------
 public | h2dbp  | index | pau   | precalc
 public | icsp   | index | pau   | local
 public | icspn  | index | pau   | names
 public | idx    | index | pau   | local
 public | iid    | index | pau   | blancprecalc
 public | ipssms | index | pau   | pssms
 public | merda1 | index | pau   |
 public | merda2 | index | pau   |
 public | merda3 | index | pau   |
(9 rows)


i would like to drop index merda1 2 and 3, but i can't because i drop their table before  drop the index

what can I do?





2008/9/16 Richard Huxton <dev@archonet.com>
Pau Marc Munoz Torres wrote:
> Hi everybody
>
>  I have a problem with index, i droped a table before drop their indexs, so,
> now i can't remove the index

That shouldn't be possible. What version of PostgreSQL is this?

--
 Richard Huxton
 Archonet Ltd



--
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

Re: drop index

From
Tom Lane
Date:
"Pau Marc Munoz Torres" <paumarc@gmail.com> writes:
>  psql 8.2.6 (server 8.2.5)
>  Schema |  Name  | Type  | Owner |    Table
> --------+--------+-------+-------+--------------
>  public | h2dbp  | index | pau   | precalc
>  public | icsp   | index | pau   | local
>  public | icspn  | index | pau   | names
>  public | idx    | index | pau   | local
>  public | iid    | index | pau   | blancprecalc
>  public | ipssms | index | pau   | pssms
>  public | merda1 | index | pau   |
>  public | merda2 | index | pau   |
>  public | merda3 | index | pau   |
> (9 rows)

This looks like evidence of corruption in the system catalogs.
I'd suggest dump/initdb/reload --- but better check that the
dump worked and seems to contain all your data before trashing
the old database...

You might want to take the opportunity to update to 8.2.latest
while at it.

            regards, tom lane