Re: drop index

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(at)archonet(dot)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(dot)munoz(at)bioinf(dot)uab(dot)cat