"Wei Wu" <w.wu@xxxxxxxxxx> writes: > Basically, we have a table X, trying to drop > it would result an error message below: > cache lookup failed for relation XXXXX You've got missing catalog rows, apparently. > I am using PgAdmin and I can still view the schema of this table, but > any operation on it would get the above error. Hmmm ... how long since the system catalogs in this database were vacuumed? > I am also wondering whether this problem has been fixed in newer > PostgreSQL releases. > BTW, our postgreSQL version is 7.4.3. It's hard to say, but you are three and a half years behind on bug fixes, some of which certainly could have led to corruption of this sort. You really should be running 7.4.19. Read the release notes here: http://www.postgresql.org/docs/7.4/static/release.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
