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 <[EMAIL PROTECTED]> > 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 : [EMAIL PROTECTED]