Re: error índice

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