pg_dump: schema with OID 58698 does not exist - Mailing list pgsql-general

From David Kerr
Subject pg_dump: schema with OID 58698 does not exist
Date
Msg-id 20110209003823.GA93840@mr-paradox.net
Whole thread Raw
Responses Re: pg_dump: schema with OID 58698 does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
howdy all,

I'm getting the above error in one of my dev DBs.

I've read in the archives that to stop the error from happening I can just
delete entries in  pg_type and pg_class, however there seemed to be some
community interest in doing some debugging.

(mentioned in this thread: http://archives.postgresql.org/pgsql-bugs/2010-01/msg00090.php )

This is PG 9.0.2 on RedHat 64 bit.

Is there anything you'd like me to check before i fix the problem?

(since it's dev, i plan to just wack the database and re-create it.. so i don't need
to worry about if that particular object was used or whatever... )

Thanks

Dave

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG)
Next
From: u235sentinel
Date:
Subject: pg_restore validation?