On Fri, Feb 11, 2011 at 03:17:51PM -0500, Tom Lane wrote:
- David Kerr writes:
- > 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?
-
- Well, it could b
David Kerr writes:
> 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?
Well, it could be any catalog with a namespace column. But I'm
wondering about pg_depend li
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 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 cor
On Wed, Feb 09, 2011 at 02:15:06PM -0500, Tom Lane wrote:
- David Kerr 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
David Kerr 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 s
On Wed, Feb 09, 2011 at 09:42:36AM -0800, David Kerr wrote:
- On Tue, Feb 08, 2011 at 10:16:02PM -0500, Tom Lane wrote:
- - David Kerr writes:
- - > I'm getting the above error in one of my dev DBs.
- -
- - Would you poke around in the system catalogs and find where the dangling
- - reference is
On Tue, Feb 08, 2011 at 10:16:02PM -0500, Tom Lane wrote:
- David Kerr writes:
- > I'm getting the above error in one of my dev DBs.
-
- Would you poke around in the system catalogs and find where the dangling
- reference is located? Have you got any idea of how to reproduce this
- failure from
David Kerr writes:
> I'm getting the above error in one of my dev DBs.
Would you poke around in the system catalogs and find where the dangling
reference is located? Have you got any idea of how to reproduce this
failure from a standing start?
regards, tom lane
--
Sent
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://archiv
