Re: drop table error

Kevin Kempter  writes:
> anyone know what would cause errors like this (postgres version 8.1.15):
> drop table bigtab1;                                                                        
> ERROR:  could not find tuple for constraint 373617
> drop sequence bigtab2_id_seq;                                                              
> ERROR:  cache lookup failed for relation 371698  

Looks like system catalog corruption to me.  If you're lucky it's only
index corruption and you could fix it with "REINDEX SYSTEM "

I seem to recall that you've had a LOT of stability problems in the
recent past.  I'm thinking that there is some underlying problem
with your system -- maybe bad hardware or a nasty kernel bug.
If Postgres were this unstable for everybody, nobody would use it.

			regards, tom lane