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:
> Dirk Lutzebäck <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