Skip site navigation (1) Skip section navigation (2)

Re: error índice

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "pedro baldovino" <pedrobaldovinomartin(at)yahoo(dot)com(dot)ar>
Cc: "pgsql-es-ayuda postgresql" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: error índice
Date: 2006-07-14 03:57:31
Message-ID: c2d9e70e0607132057o3b3bc1eqdbe61b53a9548d40@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
On 7/13/06, pedro baldovino <pedrobaldovinomartin(at)yahoo(dot)com(dot)ar> wrote:
>
> Hola lista. quiero borrar un índice y me da el siguiente error:
>
> basededatos# DROP INDEX xx.xx;
> ERROR :  cache lookup failed for index 25049
> basededatos#
>
> alguna idea? gracias
>

puedo reproducirlo:

prueba=# drop index idx_key;
ERROR:  cache lookup failed for index 33606
prueba=#

pero antes tuve que hacer:
prueba=# delete from pg_index where indexrelid = 33606 ;
DELETE 1

a que has estado jugando? que version de postgres estas usando? que
mas has instalado?

-- 
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In response to

Responses

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2006-07-14 06:19:32
Subject: Re: S.O.S. ayudente por favor.
Previous:From: Jaime CasanovaDate: 2006-07-14 03:25:34
Subject: Re: Consulta sobre insert en un bucle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group