Re: pg_dump: schema with OID 58698 does not exist

On 02/09/2011 11:23 AM, David Kerr wrote:
> On Wed, Feb 09, 2011 at 02:15:06PM -0500, Tom Lane wrote:
> - David Kerr<dmk@mr-paradox.net>  writes:
> ->  Ok, I found the bad entries, 2 tables a sequence and 2 primary key indexes are associated
> ->  with the wrong (invalid / nonexistant ) schema.
> -
> ->  However, there are correct entries for those objects as well. So these are definitly just dangling references.
> -
> - Please be more specific.  What are the bad entries exactly (what values,
> - in which columns of what catalogs) and what do you mean by "there are
> - correct entries as well"?
>
> pg_class has 5 relname entries associated with a relnamespace (58698) that doesn't exist in pg_namespace.
>
> Those relname entries corrispond to 2 tables and their PKs and a sequence (for the PK of one of the tables).
>
> Those objects do have valid entries in pg_class as well (they point to a different relnamespace)
>
> Is that more clear?

So i removed the 5 entries from pg_class, but i still get that error
when trying to pg_dump:

pg_dump: schema with OID 58698 does not exist

Any other ideas where i could look?

thanks

Dave