Re: [GENERAL] cache lookup failed for relation X

2008-03-08 Thread Tom Lane
"Wei Wu" <[EMAIL PROTECTED]> writes: > Basically, we have a table X, trying to drop > it would result an error message below: > cache lookup failed for relation X You've got missing catalog rows, apparently. > I am using PgAdmin and I can still view the schema of this table, but > any opera

[GENERAL] cache lookup failed for relation X

2008-03-08 Thread Dave Wurtz
I found some posts be developers discussing this issue last Jan. and Nov.. See link below. http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation&l=&d=&s= But have not been able to find any suggestion on how an end user can use to get around this problem. Basically, we have

[GENERAL] cache lookup failed for relation X

2008-03-08 Thread Wei Wu
I found some posts be developers discussing this issue last Jan. and Nov.. See link below. http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation &l=&d=&s= But have not been able to find any suggestion on how an end user can use to get around this problem. Basically, we ha