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
