Received: from pacs04.infoave.net (IDENT:21243877@pacs04.InfoAve.Net [165.166.0.14]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA99264 for ; Fri, 6 Aug 1999 14:14:58 -0400 (EDT) (envelope-from lamar.owen@wgcr.org) Received: from www.wgcr.org ("port 5232"@[206.74.232.194]) by InfoAve.Net (PMDF V5.1-12 #23426) with ESMTP id <01JEG7KXESJI98AP76@InfoAve.Net> for hackers@postgreSQL.org; Fri, 6 Aug 1999 14:14:09 EDT Received: from wgcr.org ([206.74.232.197]) by www.wgcr.org (8.8.7/8.8.5) with ESMTP id OAA02958; Fri, 06 Aug 1999 14:14:14 -0400 Date: Fri, 06 Aug 1999 14:14:08 -0400 From: Lamar Owen Subject: Re: [HACKERS] Unable to create tables... To: Don Baccus Cc: Postgres Hackers List Message-id: <37AB25F0.CB67F617@wgcr.org> Organization: WGCR Internet Radio MIME-version: 1.0 X-Mailer: Mozilla 4.61 [en] (Win95; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en References: <37AAFF29.958CE9F2@alumni.caltech.edu> <3.0.1.32.19990806094228.00e0388c@mail.pacifier.com> Don Baccus wrote: > I can't "drop table foo", getting an error message telling > me the class doesn't exist, so that's not the problem. > It would seem as some system table is being corrupted??? Check pg_tables and pg_class -- select * from pg_tables; will give you a list of tables from the system catalog, and select * from ps_class; will do the same for classes -- if the psuedo-dropped table shows in either of these tables, delete it, and see if that helps. If this indeed is a system table corruption..... eeewwww.... Lamar Owen WGCR Internet Radio