Re: pg_dump: schema with OID 16396 does not exist - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump: schema with OID 16396 does not exist
Date
Msg-id 26697.1156945365@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump: schema with OID 16396 does not exist  (RW <postgres@tauceti.net>)
Responses Re: pg_dump: schema with OID 16396 does not exist
List pgsql-admin
RW <postgres@tauceti.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

pgsql-admin by date:

Previous
From: RW
Date:
Subject: pg_dump: schema with OID 16396 does not exist
Next
From: "Nigel Bishop"
Date:
Subject: Re: Some advice required please