Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVOVc-0000dM-Qt for pgsql-admin@postgresql.org; Mon, 05 Nov 2012 15:22:40 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TVOVa-0006iT-VL for pgsql-admin@postgresql.org; Mon, 05 Nov 2012 15:22:40 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id qA5FMbRG027172; Mon, 5 Nov 2012 10:22:37 -0500 (EST) From: Tom Lane To: Terry Khatri cc: Lukasz Brodziak , pgsql-admin@postgresql.org Subject: Re: Fwd: Errors on pg_dumpall In-reply-to: References: <5094875F.60305@ringerc.id.au> Comments: In-reply-to Terry Khatri message dated "Mon, 05 Nov 2012 14:40:23 +0500" Date: Mon, 05 Nov 2012 10:22:37 -0500 Message-ID: <27171.1352128957@sss.pgh.pa.us> X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201211/23 X-Sequence-Number: 40268 Terry Khatri writes: > Okay, I have found a reference to that oid in pg_type as under : > select * from pg_type where typnamespace=74363 ; Okay, so you have a composite type named "city" (either a table's rowtype, or a standalone composite type --- hard to tell from just this entry) that somehow escaped deletion when the containing schema was deleted. Do you have an idea what triggered that? A reproducible test case would be even better. > What I should do next ? Well, you can just manually delete those rows in pg_type, if you're sure that there's nothing else linking to them. It might be safer to try to do it as "drop type city" first. regards, tom lane