pg_dump: schema with OID XXXXXXXXX does not exist

From: Kristofer Munn <kmunn(at)munn(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dump: schema with OID XXXXXXXXX does not exist
Date: 2004-12-06 19:25:14
Message-ID: 6.0.0.22.0.20041206141705.035cce08@209.61.238.15
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Kristofer Munn
Your email address : kmunn(at)munn(dot)com

System Configuration
---------------------

Linux db.mymailman.com 2.4.20-6smp #1 SMP Thu Feb 27 09:59:40 EST 2003 i686
i686 i386 GNU/Linux

Running dual 2.8ghz w/HT.

PostgreSQL version (example: PostgreSQL-7.4.3): PostgreSQL-7.4.3

Compiler used (example: gcc 2.95.2) :

Please enter a FULL description of your problem:
------------------------------------------------
I'm trying to do a pg_dump on my very large database and I get:

pg_dump: schema with OID 334688499 does not exist

The database has a public schema and about 30 other schemas. I am unable
to dump even individual schema (public or the others).

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
No idea how it happened or how to reproduce it. I get the error every time
I try to run a dump.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
No idea.

- Kristofer Munn

KMI www.munn.com 732-254-9305 503-905-1959(fax) AIM:KrMunn

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2004-12-06 20:28:43 Re: BUG #1292: ecpg precompile bug (valiable typedef & define )
Previous Message Tom Lane 2004-12-06 18:50:32 Re: serial drop error