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(at)aeccom(dot)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