Hi, One of my databases was running on PostgreSQL 6.5.1 and I accidentally corrupted the pg_class file. After I restored the file from a backup, postgres would come up but I can't see my tables. Only the system tables are visible and trying to SELECT * FROM mytable returned 0 rows.
SELECT * FROM pg_class only shows the system tables, but VACUUM would go through all the tables. pg_class' entry in pg_class table shows that it has 95 tuples but only 47 of them are listed when I do SELECT * FROM pg_class. Can someone help me recover my tables? Thanks. __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
