I had similar problem before. I was able to select from the_missig_table. What I did to fix my problem was to vacuum the whole database by login psql: vacuum;
Hope it helps! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wim Kerkhoff Sent: Monday, September 13, 2004 8:31 PM To: [EMAIL PROTECTED] Subject: [ADMIN] pg_class / missing tables I'm trying to recover a database where some tables 'went missing'... Short story: server was rebooted without being shut down properly, upon bootup PostgreSQL (7.4.3) starts fine, but a couple of data tables (along with their associated indexes and sequences) are gone. Other tables are still there. The missing tables aren't listed in \d or in the pg_class table, but according to the sizes of the numbered files in /var/lib/postgres/data/base/142772, the raw files must still be there. What's interested is that if I try: CREATE TABLE missing_table_name (foo int); It does complain that the table already exists... What's happening here? Many thanks, Wim ---------------------------(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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
