Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0632D9FB2D2 for ; Sun, 29 Oct 2006 22:19:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 49997-10 for ; Mon, 30 Oct 2006 02:19:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 54E6E9FB206 for ; Sun, 29 Oct 2006 22:19:17 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9U2JDCg003551; Sun, 29 Oct 2006 21:19:13 -0500 (EST) To: Peter Neish cc: pgsql-admin@postgresql.org Subject: Re: pg_dump: schema with OID xxxxxxxx does not exist In-reply-to: <45455FA3.2080706@austehc.unimelb.edu.au> References: <45418477.2020400@austehc.unimelb.edu.au> <6801.1161967193@sss.pgh.pa.us> <45455FA3.2080706@austehc.unimelb.edu.au> Comments: In-reply-to Peter Neish message dated "Mon, 30 Oct 2006 13:12:51 +1100" Date: Sun, 29 Oct 2006 21:19:13 -0500 Message-ID: <3550.1162174753@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.129 tagged_above=0 required=5 tests=SPF_HELO_PASS, SPF_PASS, SUBJECT_NOVOWEL X-Spam-Level: X-Archive-Number: 200610/197 X-Sequence-Number: 23500 Peter Neish writes: > Tom Lane wrote: >> These are composite-type entries, which means there should be >> associated entries in pg_class --- with OIDs 37894096 and 37894098 >> respectively. Did you check to see if those are still there? > Yes, they are there. Can I safely delete the rows from both the pg_type > and the pg_class tables? Oh, that's interesting. Are there entries in pg_attribute for these tables? Look for attrelid = 37894096 or 37894098. What PG version is this exactly? regards, tom lane