Re: drop index

["Pau Marc Munoz Torres" <paumarc@xxxxxxxxx>]

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

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