Re: pg_dump: schema with OID 16396 does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: RW <postgres(at)tauceti(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump: schema with OID 16396 does not exist
Date: 2006-08-30 13:42:45
Message-ID: 26697.1156945365@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

RW <postgres(at)tauceti(dot)net> writes:
> pg_dump: schema with OID 16396 does not exist

I assume you don't see that OID in "select oid,nspname from pg_namespace"?

Look through the system catalogs to find the object(s) that claim to be
in that namespace, and then tell us what they are and their history.

select * from pg_type where typnamespace = 16396

and likewise for pg_class.relnamespace, pg_operator.oprnamespace,
pg_conversion.connamespace, pg_opclass.opcnamespace,
pg_aggregate.aggnamespace, pg_proc.pronamespace.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-08-30 13:48:22 Re: Some advice required please
Previous Message RW 2006-08-30 11:23:43 pg_dump: schema with OID 16396 does not exist