Re: pg_dump: schema with OID 559701082 does not exist

Yes, I finally found the reference in pg_type.

Thanks for your help!

Regards,

Dirk


Tom Lane wrote:
> =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> 
>>I have now deleted every temp table I know from pg_temp_nnn using your 
>>approach but still can't dump the schema:
>>pg_dump: schema with OID 559701082 does not exist
>>I could'nt find any reference to  559701082 in pg_class, pg_namespace or 
>>pg_proc.
> 
> 
> Better keep looking then.  See
> http://www.postgresql.org/docs/8.1/static/catalogs.html
> (adjust link for your PG version) to find out which catalogs reference
> pg_namespace.
> 
> 			regards, tom lane