Re: BUG #5271: pg_dump: schema with OID 22519 does not exist - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5271: pg_dump: schema with OID 22519 does not exist
Date
Msg-id 603c8f071001110638n380f8612reec48c96a8af316a@mail.gmail.com
Whole thread Raw
In response to BUG #5271: pg_dump: schema with OID 22519 does not exist  ("Michael Tenenbaum" <michael@strategic-techs.com>)
List pgsql-bugs
On Mon, Jan 11, 2010 at 2:00 AM, Michael Tenenbaum
<michael@strategic-techs.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05271
> Logged by: =A0 =A0 =A0 =A0 =A0Michael Tenenbaum
> Email address: =A0 =A0 =A0michael@strategic-techs.com
> PostgreSQL version: 8.3.9
> Operating system: =A0 Gentoo Linux
> Description: =A0 =A0 =A0 =A0pg_dump: schema with OID 22519 does not exist
> Details:
>
> According to the posts I picked up from a Google search, this is a bug th=
at
> never seems to get fixed.
>
> I followed Tom's advice and deleted entries in
>
> pg_type and pg_class
>
> and pg_dump is working ok.
>
> The object was a table in a development system with only a few entries.
> hardly anything was written to the table in the past few weeks, but the
> daily pg_dump was working fine until this evening.

Maybe I should be smarter than I am, but when you say that "this" is a
bug that never seems to get fixed, I'm not sure what "this" is.  It
sounds like you're talking about system catalog corruption of some
sort, but without more details it's hard to speculate as to what might
have happened.

Unfortunately, it also sounds like you've destroyed all the
evidence... I don't suppose you have a copy of a version of the
database where this is still broken?

...Robert

pgsql-bugs by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: error after dropping column
Next
From: "Steve White"
Date:
Subject: BUG #5272: PL/Python SELECT: return composite fields as dict, not str