Re: pg_dump: schema with OID xxxxxxxx does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Neish <peter(at)austehc(dot)unimelb(dot)edu(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump: schema with OID xxxxxxxx does not exist
Date: 2006-10-30 02:19:13
Message-ID: 3550.1162174753@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Neish <peter(at)austehc(dot)unimelb(dot)edu(dot)au> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Neish 2006-10-30 02:27:02 Re: pg_dump: schema with OID xxxxxxxx does not exist
Previous Message Peter Neish 2006-10-30 02:12:51 Re: pg_dump: schema with OID xxxxxxxx does not exist