drop index

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

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

"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