Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 8B2729FB206 for ; Sun, 29 Oct 2006 22:12:49 -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 49743-07 for ; Mon, 30 Oct 2006 02:12:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4039F9FA491 for ; Sun, 29 Oct 2006 22:12:47 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from macfarlane.asap.unimelb.edu.au (macfarlane.asap.unimelb.edu.au [203.14.107.65]) by svr4.postgresql.org (Postfix) with ESMTP id 3C2E65AF889 for ; Mon, 30 Oct 2006 02:12:46 +0000 (GMT) Received: by macfarlane.asap.unimelb.edu.au (Postfix, from userid 1021) id DF47C12B01D; Mon, 30 Oct 2006 12:57:17 +1100 (EST) Received: from [203.14.107.27] (iapetus.asap.unimelb.edu.au [203.14.107.27]) by macfarlane.asap.unimelb.edu.au (Postfix) with ESMTP id D121D12AEEA; Mon, 30 Oct 2006 12:57:11 +1100 (EST) Message-ID: <45455FA3.2080706@austehc.unimelb.edu.au> Date: Mon, 30 Oct 2006 13:12:51 +1100 From: Peter Neish User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump: schema with OID xxxxxxxx does not exist References: <45418477.2020400@austehc.unimelb.edu.au> <6801.1161967193@sss.pgh.pa.us> In-Reply-To: <6801.1161967193@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.131 tagged_above=0 required=5 tests=SUBJECT_NOVOWEL X-Spam-Level: X-Archive-Number: 200610/196 X-Sequence-Number: 23499 Tom Lane wrote: > Peter Neish writes: > >> entity_browse_bid_seq | 37647910 | 1005 | 4 | t | >> c | t | , | 37894096 | 0 | record_in | >> record_out | record_recv | record_send | i | p | >> f | 0 | -1 | 0 | | >> entity_browse | 37647910 | 1005 | 4 | t | >> c | t | , | 37894098 | 0 | record_in | >> record_out | record_recv | record_send | i | p | >> f | 0 | -1 | 0 | | >> (2 rows) >> > > >> Does this mean that I can just delete these rows from this table for the >> dump to work? Will deleting these rows affect anything else? >> > > 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? > We've seen scattered reports of table rowtype entries not being removed > when the owning table is dropped, but no one's ever been able to make a > reproducible case :-(. Do you know anything about the history or usage > of these tables? > I am afraid I inherited this database from a previous admin, so I know nothing of its history - sorry... Peter.