Received: from p1.selectacast.net (IDENT:root@p1.selectacast.net [206.41.1.251]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA83901 for ; Mon, 3 Apr 2000 16:29:39 -0400 (EDT) (envelope-from jks@p1.selectacast.net) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id QAA06346; Mon, 3 Apr 2000 16:28:58 -0400 Message-ID: <38E8FF0A.1F8E940A@selectacast.net> Date: Mon, 03 Apr 2000 16:28:58 -0400 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: Robert Chalmers CC: pgsql Subject: Re: Can't access a table. It seems to have been corrupted hsomehow References: <004101bf9bb7$354380c0$1a6001cb@chalmers.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/20 Try vacuuming the database. Robert Chalmers wrote: > 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