Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E72369FB2BB for ; Sun, 29 Oct 2006 22:27:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34029-07 for ; Sun, 29 Oct 2006 22:27:25 -0400 (AST) X-Greylist: delayed 00:14:40.19844 by SQLgrey- Received: from macfarlane.asap.unimelb.edu.au (macfarlane.asap.unimelb.edu.au [203.14.107.65]) by postgresql.org (Postfix) with ESMTP id F06239FB206 for ; Sun, 29 Oct 2006 22:27:24 -0400 (AST) Received: by macfarlane.asap.unimelb.edu.au (Postfix, from userid 1021) id 0F46C12B02B; Mon, 30 Oct 2006 13:12:01 +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 F1BD912B01D; Mon, 30 Oct 2006 13:11:22 +1100 (EST) Message-ID: <454562F6.7020501@austehc.unimelb.edu.au> Date: Mon, 30 Oct 2006 13:27:02 +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> <45455FA3.2080706@austehc.unimelb.edu.au> <3550.1162174753@sss.pgh.pa.us> In-Reply-To: <3550.1162174753@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/198 X-Sequence-Number: 23501 Tom Lane wrote: > 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 > > Yes, 32 entries. # select * from pg_attribute where attrelid = 37894096 or attrelid = 37894098; attrelid | attname | atttypid | attstattarget | attlen | attnum | attndims | attcacheoff | atttypmod | attbyval | attstorage | attisset | attalign | attnotnull | atthasdef | attisdropped | attislocal | attinhcount ----------+---------------+----------+---------------+--------+--------+----------+-------------+-----------+----------+------------+----------+----------+------------+-----------+--------------+------------+------------- 37894096 | tableoid | 26 | 0 | 4 | -7 | 0 | -1 | -1 | t | p | f | i | t | f | f | t | 0 37894096 | cmax | 29 | 0 | 4 | -6 | 0 | -1 | -1 | t | p | f | i | t | f | f | t | 0 ... 37894098 | bid | 23 | -1 | 4 | 10 | 0 | -1 | -1 | t | p | f | i | t | t | f | t | 0 (32 rows) Its runnign PG Version 7.4.7 Cheers, Peter