Received: from nanguo.chalmers.com.au (gateway.chalmers.com.au [203.1.96.1]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA86064 for ; Sat, 1 Apr 2000 02:40:23 -0500 (EST) (envelope-from robert@chalmers.com.au) Received: from carbon (carbon.chalmers.com.au [203.1.96.26]) by nanguo.chalmers.com.au (8.9.3/8.9.3) with SMTP id RAA22269 for ; Sat, 1 Apr 2000 17:36:52 +1000 (EST) Message-ID: <004101bf9bb7$354380c0$1a6001cb@chalmers.com.au> Reply-To: "Robert Chalmers" From: "Robert Chalmers" To: "pgsql" Subject: Can't access a table. It seems to have been corrupted hsomehow Date: Sat, 1 Apr 2000 18:49:33 +1000 Organization: Quantum Radio MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200004/1 I have a database with a group of tables in it. One of the tables seems to have been modified somehow, and no - although I can see it with \d I can't actually do anyting to it. Any action, like rename, insert, drop gives a message "table doesn't exist". If I try to jsut creat it again, it says "can't do that, it already exists!" (words to that effect) So - does it exist or not? How do I actually get rid of that particular table all together without destroying the whole database? bob